ExcelBanter - IF function with multiple formilae

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF function with multiple formilae (https://www.excelbanter.com/excel-worksheet-functions/25819-if-function-multiple-formilae.html)

timbo1981

IF function with multiple formilae

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.

Gary's Student

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.

All times are GMT +1. The time now is 11:01 PM.