Formula to deduct should work only if sufficient balance availalble

Hi,

Please find attached sheet ref to cell AF.

I need help in changing the formula in AF as under.

If SUM(S2:X2)-(Y2:AE2) >AF2 only then AF formulae should display value, if not it should display 0

Please Login or Register  to view this content.

Originally Posted by gue2013

Please Login or Register  to view this content.

This wont work because AF is formula cell

but AF gives you already result and this result is used then.
give samples when this is fullfilled and not fullfilled- i do not understand your problem

Originally Posted by AliGW

Not sure here ...

Is this what you want?

=IF(IF($R2<=Parameters!$B$7,SUM(S2:X2)*Parameters!$B$8%,0)<SUM(S2:X2)-(Y2:AE2),IF($R2<=Parameters!$B$7,SUM(S2:X2)*Parameters!$B$8%,0),"")

Unable to verfiy I am getting error #VALUE!

This works

=IF(AND(R2<=52000,SUM(S2:X2)-SUM(Y2:AC2)>=SUM(S2:X2)*0.75%),SUM(S2:X2)*0.75%,0)