IF formula error
Thanks Matt. Alan
Matt. wrote:
I think you need to change the "&" to the word AND.
B32 & E16 will concatenate to 500040000
cheers,
Matt.
"Alan Secker" wrote in message
...
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
|