LinkBack URL
About LinkBacks
Hi friends,
I have inserted a sum formula in cell e6 but I'm not getting correct output. In this case I want the correct output in cell e6 '-2350' but I'm getting '2350' which is wrong.
Please suggest me a correction.
Thank you.
Mukesh
Hi friends,
I have inserted a sum formula in cell e6 but I'm not getting correct output. In this case I want the correct output in cell e6 '-2350' but I'm getting '2350' which is wrong.
Please suggest me a correction.
Thank you.
Mukesh
Try it in a calculator, you are subtracting a negative value from zero (essentially zero minus a minus value) so you are getting a positive value.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
Do you need to note a debit as a minus? Doesn't the term debit already suggest that? If you don't need to note it as such then change your formula in col C to =ABS(IF(SUM(Y4:Y10)=0,0,IF(SUM(Y4:Y10)<0,VALUE(SUM(Y4:Y10)),""))) and you'll get the balance value in E6 you want.
Hi,
You should enter your debits as a positive figure (its a standard math thing which I know but cant explain!!!!) if you do that then your calculation works ok.
Or:
Change your formula as example below to use absolute function which ignores the positive or negative value
Regards
Please Login or Register to view this content.
Steve
Hello Sambo kid,
Thank you for suggestion. The absolute formula gave me the correct output as per my requirement.
Thank you.
Mukesh
Hi Steve@TRW,
Thank you for suggestion. It's working fine. Both the formulas are giving correct output.
Regards,
Mukesh
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks