Hi all,
I have the following formula and it doesnt seem to work...
=IF(P59>0,SUM(P64-N59)*(0.29),"-")
Can anyone help?
Thanks
loopiloo
Hi all,
I have the following formula and it doesnt seem to work...
=IF(P59>0,SUM(P64-N59)*(0.29),"-")
Can anyone help?
Thanks
loopiloo
Works for me, in what way does it not work for you?
Do you get an error? What error?
Do you get the wrong result? What result DO you get? What result were you expecting?
What are the values in each of the 3 cells involved?
What result do you get?
You don't need the SUM function:
=IF(P59>0,(P64-N59)*0.29,"-")
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
It would return a false when it should have returned a true
The problem seems to be that P59 is the cell where the formula is so it seems that some cross referencing is going on...
Ive changed the formula to =IF(P64>N59,SUM(P64-N59)*(0.29),"-") and it seems to be ok...
Last edited by loopiloo; 06-10-2016 at 04:04 AM.
Forgot about the SUM. Thanks for your help...
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks