Need help on the excel formula

[brian8989]

Hi Excel Experts,

I wish to create a formula which if H4 contains Greater, then A4-C4, otherwise C4-A4. I do not know why the formula below did not work (highlighted in RED), hence, I need your kind assistance on this issue.

=IF(ISNUMBER(SEARCH("Greater",H4))," =ASB(A4-C4) ","=ASB(C4-A4)")




Thank you in advance!

Regards,
Brian

 

[jmacleary]

Hi. Try =IF(H4="Greater",A4-C4,C4-A4)

 

[brian8989]

Hi Jmacleary,

Thank you for the help. What if I want the number to be always positive?

For instance, A4 = 100, C4 = 50

C4-A4, and I want the result to be positive.


Thanks and Regards,
Brian

 

[jmacleary]

In that case, you dont need the IF clause at all, just code =ABS(A4-C4)