Thread: Multiple if functions in Excel 2003

Hi guys
Can someone point out to me the error of my ways with the following formula.
It has been driving me nuts but I am fairly new to this so I am obviously missing something probably very simple.
Where the value I want to display in the chosen cell E39 is based on the value of either D39 or K39?
=IF(D39>0,85,0),IF(K39=85,32,0))
Not sure how to compensate if both D39 and K39 requirements are met at the same time??
Thanks for any help that may be forthcoming.
Kind regards
Wayne

=IF(D39>0,85,0),IF(K39=85,32,0))

Maybe:

=IF(D39>0,85,IF(K39=85,32,0))

Regards

Originally Posted by TMShucks

Maybe:

=IF(D39>0,85,IF(K39=85,32,0))

Regards

Yes you are absolutely correct. I just knew it was going to be something simple and it further proves that knowledge is power. Thank you very much for providing your knowledge, it is much appreciated.
But is there a simple explanation for this that may flow through to other formulae computations that I might attempt. It seems to me that in this case the values for the ''False'' were the same ie ''0'' yet it caused the formula not to work??
Kindest regards
Wayne

The basic IF statement is =IF(condition, value if true, value if false). The values can be numeric, text, a cell address, or another formula, for example, another IF statement

So, you can have: =IF(condition 1, value if true, IF(condition 2, value if true, IF(condition 3, value if true, value if false))) ... and so on.

As the conditions in this case look to be independant, it is important to decide on the order of priority. Checking K39 befor D39 could have a different outcome altogether defending on the values in those cells.

Thanks for the rep.

If this has answered your question, please mark your thread as solved.

Regards