How do I get a formula to show if a surplus or loss.

[ghrek]

Hi

I have a workbook that im trying to get it to work out if a surplus or loss and then put in one specific place.

I have a value in cell E28 and also values in cells O23 and T31

What im trying to do is the following..

If the value of cell E28 is GREATER than the values of cells O23&T31 combined then I need the difference between the two put into cell I44
or
If the value of cell E28 is LESS than the values of cells O23&T31 combined then I need the difference between the two put into cell E44

Any Ideas?

 

[Joe4]

You are welcome.
Glad we were able to help.