ExcelBanter - I put a Calc. in to get a total IE =K12 the answer comes up as 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - I put a Calc. in to get a total IE =K12 the answer comes up as 0 (https://www.excelbanter.com/excel-discussion-misc-queries/60708-i-put-calc-get-total-ie-%3Dk12-answer-comes-up-0-a.html)

I put a Calc. in to get a total IE =K12 the answer comes up as 0

My Calculation is $28,000.00 i have asked it to be placed in another area as
a part of totals, but it appears as 0.00 (argument is E5=K12)

Roger Govier

I put a Calc. in to get a total IE =K12 the answer comes up as0

Hi
Perhaps your calculation is set to manual
ToolsOptionsCalculation and click on Automatic

Regards

Roger Govier

G4 wrote:
My Calculation is $28,000.00 i have asked it to be placed in another area as
a part of totals, but it appears as 0.00 (argument is E5=K12)

All times are GMT +1. The time now is 06:44 PM.