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.