Excel Oddity

  • Thread starter Thread starter Aardvark
  • Start date Start date
A

Aardvark

Dear all,

Someone showed me an if statement, which was not working. The cells to
which it referred were all formatted correctly (currency / accountancy) yet
the statement returned an error. I deleted the cells in the logical test
and re-entered them...I did not change the formatting, and this time it
worked. To the best of my knowledge currency signs, commas etc were not
entered manually but via cell formatting. Anyone met this before?

Thanks

Danny
 
OK. it was

=if(f10>40000,(f10-40000)*6%,"")

The cell that I deleted and replaced was f10.

Thankls for your help.

Danny
 
Back
Top