software

At this time I use the present formula:

If (b3 gt; 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: www.excelforum.com/member.php...oamp;userid=30848
View this thread: www.excelforum.com/showthread...hreadid=515131Just amend your formula as follows:

IF (B3 gt;= 10, 0, B3)

Hope this helps.

PeteOr
if b3gt;9

--
Don Guillett
SalesAid Software

quot;kiefferquot; gt; wrote in
message ...
gt;
gt; At this time I use the present formula:
gt;
gt; If (b3 gt; 10, 0, b3) If b3 is greater than 10 then enter 0 else enter
gt; b3's value
gt;
gt; What if I wanted to ask the following:
gt; If b3 is greater than 10 or = to 10 then 0 else b3
gt;
gt; How can this be put into a formula?
gt;
gt;
gt; --
gt; kieffer
gt; ------------------------------------------------------------------------
gt; kieffer's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30848
gt; View this thread: www.excelforum.com/showthread...hreadid=515131
gt;

=b3*(b3gt;=10)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=515131
If (b3 gt;= 10, 0, b3)

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

if(b3 lt; 10, c3)

Can't both of these be combined into 1 formula?--
kieffer
------------------------------------------------------------------------
kieffer's Profile: www.excelforum.com/member.php...oamp;userid=30848
View this thread: www.excelforum.com/showthread...hreadid=515131
You can't combine those because they conflict.

Your first IF statement says that if B3gt;=10 return 0, otherwise, i.e.
if B3lt;10, return B3

Your second statement says that if B3lt;10 return C3, you can't return
both B3and C3--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: 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(b3gt;=10,b3,c3)--
intruder9
------------------------------------------------------------------------
intruder9's Profile: www.excelforum.com/member.php...oamp;userid=30107
View this thread: www.excelforum.com/showthread...hreadid=515131if(b3gt;9,b3,c3)

--
Don Guillett
SalesAid Software

quot;kiefferquot; gt; wrote in
message ...
gt;
gt; If (b3 gt;= 10, 0, b3)
gt;
gt; If I want to keep the above but add on the following:
gt;
gt; if(b3 lt; 10, c3)
gt;
gt; Can't both of these be combined into 1 formula?
gt;
gt;
gt; --
gt; kieffer
gt; ------------------------------------------------------------------------
gt; kieffer's Profile:
gt; www.excelforum.com/member.php...oamp;userid=30848
gt; View this thread: www.excelforum.com/showthread...hreadid=515131
gt;
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