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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Principal & Interest Formula 1
Help to shorten a formula 5
Formula 6
sum formula 1
Monthly, Quarterly formulas 2
Help with multiplication formula 1
conditional formula needed 2
eliminate zero 5

Back
Top