Hi guys,
I would like to ask for your help with an If function.
What I would like to do can be seen below:
IF A>0 and B>0 see "X"
IF A>0 and B=0 see "W"
IF A=0 and B>0 see "Z"
If A=0 and B=0 see "Y"
<tbody>
</tbody>
Thank you for the help in advance
Greg
I would like to ask for your help with an If function.
What I would like to do can be seen below:
IF A>0 and B>0 see "X"
IF A>0 and B=0 see "W"
IF A=0 and B>0 see "Z"
If A=0 and B=0 see "Y"
From | To | Result |
16 | 18 | X |
17 | 0 | W |
0 | 19 | Z |
0 | 0 | Y |
<tbody>
</tbody>
Thank you for the help in advance
Greg