multiple if conditions

[naciovica]

Good day!
i have a table with 4 columns.
col1 col2 col3 col4
Please help me with a formula that outputs the following:
col1=empty & col2=empty & col3=empty & col4=empty => output a
col1>0 & col2=empty & col3=empty & col4=empty => output b
col1>0 & col2>0 & col3=empty & col4=empty => output c
col1>0 & col2>0 & col3>0 & col4=empty => output d
col1>0 & col2>0 & col3>0 & col4>0 => output e
i've tried all the if/and and if/or formulas but i don't find the solution.
Thanks in advance.
Have a nice day!

 

[KennyGreens]

Hi there, try something like this:

=IF(AND(A2=0, B2=0, C2=0, D2=0), "a", IF(AND(A2>0, B2=0, C2=0, D2=0), "b", IF(AND(A2>0, B2>0, C2=0, D2=0), "c", IF(AND(A2>0, B2>0, C2>0, D2=0), "d", IF(AND(A2>0, B2>0, C2>0, D2>0), "e", "")))))

 

[bobsan42]

What happens if values are less or equal to 0???
Normally you could use nested IFs. But here you present 5 cases, while there is total of 2^4=16 possible combinations (excluding possibilities for 0 and negative numbers).
The simplest way to achieve what you presented IMO is:

=IF(AND(ISBLANK(col1),ISBLANK(col2),ISBLANK(col3),ISBLANK(col4)),output a,
IF(AND(col1>0,ISBLANK(col2),ISBLANK(col3),ISBLANK(col4)),output b,
IF(AND(col1>0,col2>0,ISBLANK(col3),ISBLANK(col4)),output c,
IF(AND(col1>0,col2>0,col3>0,ISBLANK(col4)),output d,
IF(AND(col1>0,col2>0,col3>0,col4>0),output e)
))))

This must all go in a single line formula. However there are a lot of possibilities unaccounted for - in these cases the formula will evaluate to FALSE.

 

[naciovica]

thanks. this worded. i added one more condition to have an output of empty cell.