IF formula needed....HELP!!

  • Thread starter Thread starter Glenn Donnelly
  • Start date Start date
G

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.
 
Thank you everyone for your support. It worked like a charm.

Much appreciated.

Glenn
 
Back
Top