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.

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.

No IFs are needed:

Try something like =(A1=0)*0 + (A1<0)*B1 + (A10)*B2
--
Gary's Student


"timbo1981" wrote:

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.