View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan Secker Alan Secker is offline
external usenet poster
 
Posts: 3
Default IF formula error

I'm getting the wrong values out of the following formula.
The variable to plug in a

E16 == 40000
B32 == 5000

The IF statement is:

=IF(E16 B32 & E16 60000, 30000, E16-B32)

It should give, from left to right:

E16 B32 returns TRUE
But
B32 is not 60000 so it returns FALSE
So Result is not 30000
but
E16 - B32 which is 35000

but I get 30000

I'm clearly handling the & wrongly. Would someone be kind enough
to put me straight?

TIA

Alan Secker