• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

False error

D

drewszone32

Member
I have the below formula in worksheet. It works when there is information in C7 greater than 0.When I move across and C7 is less than 0 then it gives me false.


What am I missing?


=IF(C7>0,SUM(C38+C18-C33-C29),IF(C7<0,SUM(C18-C33-C29)))
 
It look right, make sure you are locking C7 ($C$7)


Keep in mind that whenever C7 = 0, it will return FALSE.
 
Hi ,


This is not related to your problem , but just to say that the use of the SUM function is not necessary.


SUM(C18-C33-C29) and SUM(C38+C18-C33-C29)


are the same as


C18-C33-C29 and C38+C18-C33-C29 respectively.


Narayan
 
You must log in or register to reply here.
Back
Top