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?
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?