Microsoft Word - Using Formula in table doesn't calculate - Microsoft Community

-

i'm busy trying create new salary slip should using exel find word easier operate.

so have sum example 2 400.00 - 40.19 should 2 382.81. instead gives me 382.81? doesn't give me thousand digit should get. possibly doing wrong? 

note: amount 2 400 , 40.19 formulated given correct calculation. 

it's not clear whether you're using a table without fields, formfields calculate results returned other formfield calculations or if you're using formula field.

this long-standing known bug calculation formfields input other calculation formfields. solution not use them; instead, use formula fields.

even formula field, however, if input has spaces thousands separators, word not going able calculate correct results; need use normal thousands separators.



Office / Word / Windows 10 / Office 2016



Comments

Post a Comment

Popular posts from this blog

Word VBA userform - Microsoft Community

-
have word userform 'shows' word document opens. near completion design encountering problems when open word. 'word has stopped working 'error message , cannot understand why inconsistent , error message not, once error message version of userform ruined , cannot opened. has else experienced error? Office / Word / Microsoft Office Programming / Office 2013
Read more

KB2566790 Persists after Creating DNS Records - Microsoft Community

-
Image
hello, we trying use skype business. tried sign in, , got following error. we followed the  instructions here . used remote connectivity analyzer , failed. we added srv , cname records our dns server, , the  remote connectivity analyzer  passed 4. however, still cannot log skype business, , same error when try. when adding srv records, our dns server did not have place enter service or protocol, entered them in "name" field using following pattern: _service._protocol.domain.com what else wrong? **post transferred skype office skype business better assistance.** seems took little time dns server register new entries. it's working now. Office / Skype for Business / Windows 10 / Office 365 for business
Read more

Outlook 2016 for Mac - Multiple Issues, Error 17884 - Microsoft Community

-
working mac users @ business. have few issues outlook 2016 not seem have clear cut solutions can find searching community. new emails - messages sporadically go straight outbox after being sent, not send until user exits re-opens outlook, work after multiple restarts. error code see corresponding 17884 sync status - thousands of items have yet synced. sync status show proper statistics items syncing, statistics change 'server busy' , have no idea if still syncing in background or hung up. using 'sync folder' or 'send & receive' stack more items sync status window no progress made. connection window in bottom right corner - upon start up, display 'not connected'. can leave outlook open prolonged period of time , never change, if change status of outlook online offline multiple times in tools window. so far have rebuilt profile scratch within outlook tried opening outlook on multiple wifi networks tried ope...
Read more