Adding a criteria to an IF

[stevelake]

Hi,

In the following formula l want to add an extra criteria, l know it can be done but just cant find how

The formula is

=IF(SUM($E18:$E28)>G7,SUM($E$18:E28)-G7,"")

I want to add after =IF(SUM($E18:$E28)>G7 another criteria which is

IF G8>0 - This will only make the formula work is the number in G8 is greater then 0

Thanks IN ADVANCE

stEVE

 

[al_b_cnu]

Hi,

Try

=IF(AND(G8>0,SUM($E18:$E28)>G7),SUM($E$18:E28)-G7,"")

 

[stevelake]

Great thanks!

I was trying to use the AND but l was putting it in the wrong place, works well now