Forum Discussion
Nested If function with multiple criteria
In the IF statement =IF(C36>D36,(SUM(D36-C36)),(SUM(D36-C36))) In the 2nd SUM area I want to put the word "Credit" after the result of D36-C36. How can I do this? I am currently using Office 2007. T...
=IF(C36>D36,D36-C36,D36-C36&" Credit")
This is enough. riveter2.