Hi
Try this in C3
=IF(A1=0,0,IF(A1<0,B1,B2))

--
Andy.


"timbo1981" wrote in message
...
I'm trying to do an IF function with multiple formulae. Example in words.
If
A1=0 then C3=0, if A1=<0 C3=B1, and if A10 C3=B2. a bit complicated i
think,
maybe i'm missing an obvious equation. Any help greatly received.