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?


--
kieffer
------------------------------------------------------------------------
kieffer's Profile: http://www.excelforum.com/member.php...o&userid=30848
View this thread: http://www.excelforum.com/showthread...hreadid=515131

Just amend your formula as follows:

IF (B3 = 10, 0, B3)

Hope this helps.

Pete

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

Or
if b39

--
Don Guillett
SalesAid Software

"kieffer" wrote in
message ...

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?


--
kieffer
------------------------------------------------------------------------
kieffer's Profile:
http://www.excelforum.com/member.php...o&userid=30848
View this thread: http://www.excelforum.com/showthread...hreadid=515131

=b3*(b3=10)


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515131

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?


--
kieffer
------------------------------------------------------------------------
kieffer's Profile: http://www.excelforum.com/member.php...o&userid=30848
View this thread: http://www.excelforum.com/showthread...hreadid=515131

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


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=515131

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)


--
intruder9
------------------------------------------------------------------------
intruder9's Profile: http://www.excelforum.com/member.php...o&userid=30107
View this thread: http://www.excelforum.com/showthread...hreadid=515131

if(b39,b3,c3)

--
Don Guillett
SalesAid Software

"kieffer" wrote in
message ...

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?


--
kieffer
------------------------------------------------------------------------
kieffer's Profile:
http://www.excelforum.com/member.php...o&userid=30848
View this thread: http://www.excelforum.com/showthread...hreadid=515131