IF formula needed....HELP!!

[Glenn Donnelly]

What do I need to do in order to make this work.

This formula in cell E20
=IF(E5>13050,(E5*0.05),"") this value is 0 (zero) in this scenario.

This is the formula in G20
=G18-E20

The result I am recieving is #Value

When we sum the total in column G the results are #Value even though
in several cells there are $ amounts allocated.

Hope this is clear enough, if not please email me.

Thanks.

 

[Mike Hughes]

Try

=IF(E5>13050,(E5*0.05),0)

Mike

 

[Alan Cocks]

Glen

It works if you change the formula to:

=IF(E5>13050,(E5*0.05),0)

Alan Cocks

 

[Guest]

YOUR TRYING TO SUBTRACT NULL TEXT.
USE IF(E5>13050,(E5*0.05),0) INSTEAD OF "" USE ZERO

 

[Glenn Donnelly]

Thank you everyone for your support. It worked like a charm.

Much appreciated.

Glenn