software

I want to do something that should be very easy, but its not working.
Perhaps you experts can help. =)

I would like to do the following:
IF F5 is greater than 3999 then 10,
IF F5 is less than 2500 then -10,
IF F5 is blank then blank

***A5 is the cell of course***

I've tried these two formulas but they keep coming back with -10 if the
cell is blank.

=IF((F5gt;3999),10,IF((F5lt;2500),-10,IF((F5=quot;quot;),quot;quot;,quot;quot;)

and

=IF(F5gt;3999),10, IF(F5lt;2500),-10,IF(F5=quot;quot;),quot;quot;,quot;quot;)))

Thank you, thank you, thank you-
Aajaxx--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: www.excelforum.com/member.php...oamp;userid=31129
View this thread: www.excelforum.com/showthread...hreadid=507950What should happen between 2500 and 3999?

=IF(F5=quot;quot;,quot;quot;,IF(F5lt;2500,-10,IF(F5gt;3999,10,quot;whathappensherequot;)))

Aajaxx wrote:
gt;
gt; I want to do something that should be very easy, but its not working.
gt; Perhaps you experts can help. =)
gt;
gt; I would like to do the following:
gt; IF F5 is greater than 3999 then 10,
gt; IF F5 is less than 2500 then -10,
gt; IF F5 is blank then blank
gt;
gt; ***A5 is the cell of course***
gt;
gt; I've tried these two formulas but they keep coming back with -10 if the
gt; cell is blank.
gt;
gt; =IF((F5gt;3999),10,IF((F5lt;2500),-10,IF((F5=quot;quot;),quot;quot;,quot;quot;)
gt;
gt; and
gt;
gt; =IF(F5gt;3999),10, IF(F5lt;2500),-10,IF(F5=quot;quot;),quot;quot;,quot;quot;)))
gt;
gt; Thank you, thank you, thank you-
gt; Aajaxx
gt;
gt; --
gt; Aajaxx
gt; ------------------------------------------------------------------------
gt; Aajaxx's Profile: www.excelforum.com/member.php...oamp;userid=31129
gt; View this thread: www.excelforum.com/showthread...hreadid=507950

--

Dave Peterson

Try this variation:

=IF(F5gt;3999,10,IF(F5lt;2500,-10,IF(F5=quot;quot;,quot;quot;,quot;nonequot;)))

I've added quot;nonequot; to help you test it out - you can easily change back
to quot;quot; when you are satisfied that it works.

Hope this helps.

PeteA blank is less than 2500, that's why you're getting the -10 result. Put the
test for blank first, as in:

=if(f5=quot;quot;,quot;quot;,if( ...

--
Regards,
Fredquot;Aajaxxquot; gt; wrote in message
...
gt;
gt; I want to do something that should be very easy, but its not working.
gt; Perhaps you experts can help. =)
gt;
gt; I would like to do the following:
gt; IF F5 is greater than 3999 then 10,
gt; IF F5 is less than 2500 then -10,
gt; IF F5 is blank then blank
gt;
gt; ***A5 is the cell of course***
gt;
gt; I've tried these two formulas but they keep coming back with -10 if the
gt; cell is blank.
gt;
gt; =IF((F5gt;3999),10,IF((F5lt;2500),-10,IF((F5=quot;quot;),quot;quot;,quot;quot;)
gt;
gt; and
gt;
gt; =IF(F5gt;3999),10, IF(F5lt;2500),-10,IF(F5=quot;quot;),quot;quot;,quot;quot;)))
gt;
gt; Thank you, thank you, thank you-
gt; Aajaxx
gt;
gt;
gt; --
gt; Aajaxx
gt; ------------------------------------------------------------------------
gt; Aajaxx's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31129
gt; View this thread: www.excelforum.com/showthread...hreadid=507950
gt;

In between 2501 - 3999 the value is 0.

Good question, sometimes you forget the obvious.--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: www.excelforum.com/member.php...oamp;userid=31129
View this thread: www.excelforum.com/showthread...hreadid=507950On Thu, 2 Feb 2006 20:19:47 -0600, Aajaxx
gt; wrote:

gt;
gt;In between 2501 - 3999 the value is 0.
gt;
gt;Good question, sometimes you forget the obvious.=IF(F5=quot;quot;,quot;quot;,HLOOKUP(F5,{-1E 307,2500,4000;-10,0,10},2))--ron

Perhaps another version if thought of as a signal pulse...

=IF(A1=quot;quot;,quot;quot;,10*((A1gt;3900) (A1gt;=2500)-1))

--
HTH. :gt;)
Dana DeLouis
Windows XP, Office 2003quot;Aajaxxquot; gt; wrote in
message ...
gt;
gt; In between 2501 - 3999 the value is 0.
gt;
gt; Good question, sometimes you forget the obvious.
gt;
gt;
gt; --
gt; Aajaxx
gt; ------------------------------------------------------------------------
gt; Aajaxx's Profile:
gt; www.excelforum.com/member.php...oamp;userid=31129
gt; View this thread: www.excelforum.com/showthread...hreadid=507950
gt;

This was presented to me and it works like a charm!

=IF(ISBLANK(F5),quot;quot;,IF(F5gt;3999,10,IF(F5lt;2500,-10,0)))

Thanks everyone for your help. I really appreciated it.

AJ--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: www.excelforum.com/member.php...oamp;userid=31129
View this thread: www.excelforum.com/showthread...hreadid=507950Try:

=IF(F5=quot;quot;,quot;quot;,IF(F5gt;3999,10,IF(F5lt;2500,-10,quot;quot;)))

cell will be left blank if F5 is between 2500 and 3999

HTH
JG

quot;Aajaxxquot; wrote:

gt;
gt; I want to do something that should be very easy, but its not working.
gt; Perhaps you experts can help. =)
gt;
gt; I would like to do the following:
gt; IF F5 is greater than 3999 then 10,
gt; IF F5 is less than 2500 then -10,
gt; IF F5 is blank then blank
gt;
gt; ***A5 is the cell of course***
gt;
gt; I've tried these two formulas but they keep coming back with -10 if the
gt; cell is blank.
gt;
gt; =IF((F5gt;3999),10,IF((F5lt;2500),-10,IF((F5=quot;quot;),quot;quot;,quot;quot;)
gt;
gt; and
gt;
gt; =IF(F5gt;3999),10, IF(F5lt;2500),-10,IF(F5=quot;quot;),quot;quot;,quot;quot;)))
gt;
gt; Thank you, thank you, thank you-
gt; Aajaxx
gt;
gt;
gt; --
gt; Aajaxx
gt; ------------------------------------------------------------------------
gt; Aajaxx's Profile: www.excelforum.com/member.php...oamp;userid=31129
gt; View this thread: www.excelforum.com/showthread...hreadid=507950
gt;
gt;


Thank you everyone for your help.

I got the formula that works perfect.

=IF(ISBLANK(F5),quot;quot;,IF(F5gt;3999,10,IF(F5lt;2500,-10,0)))

The key was the ISBLANK.

The spreadsheet works perfect now.

Thanks again-
AJ--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: www.excelforum.com/member.php...oamp;userid=31129
View this thread: www.excelforum.com/showthread...hreadid=507950