Combining "IF" statements

  • Thread starter Thread starter Bran987
  • Start date Start date
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
 
Hi
try
=IF(A1>50000,A1+SUM(H2:H4),IF(AND(A1>=2000,A1<=10000),A1-K4-K6+P7,IF(A1
<1000,A1+C5)))

Note: It is not possible to 'zero out' cell C5 in this process. a
formula can't do this
 
=IF(AND(cond1, OR(cond2, cond3)), result1, result2)

=IF(H50>50000,H50+H2+H3+H4,IF(AND(H50>2000,H50<1000),H50-K4-K6+P7,IF(H50<100
0,C5,"")))

but you can't zeroise C5 at the same time.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Did I ask a stupid question? If I did I'm sorry but if I need to try t
explain it more clearly or something just let me know and I'll give i
a shot. Dying at work over here
 
Back
Top