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...
Hi,
You may use formula =C36-D36 and apply custom format to this cell adding word Credit to positive numbers and nothing to negative.
I'm on mobile and it's bit hard to give exact details, you may Google "Excel custom formatting" or like
You may use formula =C36-D36 and apply custom format to this cell adding word Credit to positive numbers and nothing to negative.
I'm on mobile and it's bit hard to give exact details, you may Google "Excel custom formatting" or like