If statements

K

kieffer

At this time I use the present formula:

If (b3 > 10, 0, b3) If b3 is greater than 10 then enter 0 else enter
b3's value

What if I wanted to ask the following:
If b3 is greater than 10 or = to 10 then 0 else b3

How can this be put into a formula?
 
K

kieffer

If (b3 >= 10, 0, b3)

If I want to keep the above but add on the following:

if(b3 < 10, c3)

Can't both of these be combined into 1 formula?
 
D

daddylonglegs

You can't combine those because they conflict.

Your first IF statement says that if B3>=10 return 0, otherwise, i.e.
if B3<10, return B3

Your second statement says that if B3<10 return C3, you can't return
both B3and C3
 
I

intruder9

If you are no longer interested in returning 0 but want the contents of
c3 if b3 is less than 10 then you can use the following
IF(b3>=10,b3,c3)
 
C

Cutchember

I am trying to write a statement that compares to cells and assigns a value.
there is a lot of data, and I am not certain that it can be done, any help
would be appreciated, ... this is what I am working with ...

70% pay scale: 1 - 500 hrs worked / entry level
80% pay scale: 501 - 1000 hrs worked and 24 hrs or more training courses
90% pay scale: 1001 - 1500 hrs worked and 48 hrs or more training courses
95% pay scale: 1501 - 2000 hrs worked and 48 hrs or more training courses
100% pay scale: 2001 + hrs worked and 72 hrs or more training courses

-AC
 
Top