Hi All
Im trying to calculate an overpayment based on the value of two cells, so i have my if formula calculating a true value if cell 1 is <0 and a false if cell 1 is >0 but if the formulas calculation returns a negative i need it to show £0 as the result....
I dont know how to build this in any ideas?
Dan
Book1.xlsx
Bookmarks