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((F53999),10,IF((F5<2500),-10,IF((F5=""),"","")

and

=IF(F53999),10, IF(F5<2500),-10,IF(F5=""),"","")))

Thank you, thank you, thank you-
Aajaxx


--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950

What should happen between 2500 and 3999?

=IF(F5="","",IF(F5<2500,-10,IF(F53999,10,"whathappenshere")))

Aajaxx wrote:

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((F53999),10,IF((F5<2500),-10,IF((F5=""),"","")

and

=IF(F53999),10, IF(F5<2500),-10,IF(F5=""),"","")))

Thank you, thank you, thank you-
Aajaxx

--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950

--

Dave Peterson

Try this variation:

=IF(F53999,10,IF(F5<2500,-10,IF(F5="","","none")))

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

Hope this helps.

Pete

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

=if(f5="","",if( ...

--
Regards,
Fred


"Aajaxx" wrote in message
...

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((F53999),10,IF((F5<2500),-10,IF((F5=""),"","")

and

=IF(F53999),10, IF(F5<2500),-10,IF(F5=""),"","")))

Thank you, thank you, thank you-
Aajaxx


--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile:
http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950

In between 2501 - 3999 the value is 0.

Good question, sometimes you forget the obvious.


--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950

On Thu, 2 Feb 2006 20:19:47 -0600, Aajaxx
wrote:


In between 2501 - 3999 the value is 0.

Good question, sometimes you forget the obvious.


=IF(F5="","",HLOOKUP(F5,{-1E+307,2500,4000;-10,0,10},2))


--ron

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

=IF(A1="","",10*((A13900)+(A1=2500)-1))

--
HTH. :)
Dana DeLouis
Windows XP, Office 2003


"Aajaxx" wrote in
message ...

In between 2501 - 3999 the value is 0.

Good question, sometimes you forget the obvious.


--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile:
http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950

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

=IF(ISBLANK(F5),"",IF(F53999,10,IF(F5<2500,-10,0)))

Thanks everyone for your help. I really appreciated it.

AJ


--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950

Try:

=IF(F5="","",IF(F53999,10,IF(F5<2500,-10,"")))

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

HTH
JG

"Aajaxx" wrote:


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((F53999),10,IF((F5<2500),-10,IF((F5=""),"","")

and

=IF(F53999),10, IF(F5<2500),-10,IF(F5=""),"","")))

Thank you, thank you, thank you-
Aajaxx


--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950

Thank you everyone for your help.

I got the formula that works perfect.

=IF(ISBLANK(F5),"",IF(F53999,10,IF(F5<2500,-10,0)))

The key was the ISBLANK.

The spreadsheet works perfect now.

Thanks again-
AJ


--
Aajaxx
------------------------------------------------------------------------
Aajaxx's Profile: http://www.excelforum.com/member.php...o&userid=31129
View this thread: http://www.excelforum.com/showthread...hreadid=507950