B
Bran987
ok I know for instance:
=IF(H50<0,0,H49)
in other words I know how to do one IF statement, but what if I need t
have more conditions?
Such as:
If value in cell is greater than 50,000, add cell H2 and H3 and H4 t
it
AND
If value in that SAME cell is between 2,000 and 10,000, subtract cell
K4 and K6 and add P7
AND
If value in that SAME cell is less than 1,000, take the value in cel
C5 and add it, zeroing out cell C5 in the process
how do I combine statements like this? Besides only one statement i.e
=IF(logical_test,Value if True, Value if False)
Thanks so muc
=IF(H50<0,0,H49)
in other words I know how to do one IF statement, but what if I need t
have more conditions?
Such as:
If value in cell is greater than 50,000, add cell H2 and H3 and H4 t
it
AND
If value in that SAME cell is between 2,000 and 10,000, subtract cell
K4 and K6 and add P7
AND
If value in that SAME cell is less than 1,000, take the value in cel
C5 and add it, zeroing out cell C5 in the process
how do I combine statements like this? Besides only one statement i.e
=IF(logical_test,Value if True, Value if False)
Thanks so muc