Excel Oddity

[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

 

[Chip Pearson]

Perhaps you could post the formula in question.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Aardvark]

OK. it was

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

The cell that I deleted and replaced was f10.

Thankls for your help.

Danny