Good Morning,
I am looking to make a formula that will add up a range of cells, minus a few other cells, then compare it to 1.75 -- if the sum of those cells is greater than 1.75 -- I want it to reply with the how much greater the value is than the 1.75
So far example.
Cells K2:DD2 - Cells K2, L2, M2, N2, O2 = 2.75
I want it to see that 2.75 > 1.75 and the result displayed in the cell would be 1 (it's 1 point greater than its comparison) If it is NOT greater than 1.75, I want it to display 0
I think it would be something like this:
=(IF(AND(SUM((K2:DD2)-K2,L2,M2,N2,O2)),>1.75),1.75-(SUM(K2:DD2)-K2,L2,M2,N2,O2)),0)
Bookmarks