hineshines
New Member
- Joined
- Mar 9, 2016
- Messages
- 25
I have 3 cells.
Q,S and U
If Q2 is less than 1, I need it to return 0
If Q2 equals1, I need it to return 1
If Q2 shows any number greater than 0, It will also populate cell U2 with number 1.
If S2 is greater than 0, it will show actual count.
If U2 equals 1 and S2 is greater than 0, I need to show S2 + U2.
=IF(Q2<1,0,IF(Q2=1,1,IF(S2>1,S2+U2)))
Any help is appreciated.
Q,S and U
If Q2 is less than 1, I need it to return 0
If Q2 equals1, I need it to return 1
If Q2 shows any number greater than 0, It will also populate cell U2 with number 1.
If S2 is greater than 0, it will show actual count.
If U2 equals 1 and S2 is greater than 0, I need to show S2 + U2.
=IF(Q2<1,0,IF(Q2=1,1,IF(S2>1,S2+U2)))
Any help is appreciated.