software

I need to write a formula that looks at a set of cells and determines if they
equal quot;Fquot; or if they have numerical value of less than 59 and/or greater than
1. How would I write this? If quot;Fquot; does not appear in any of the cells, then I
want it to equal quot;Zquot;. If the numerical value is 0 or greater than 59, I want
it to equal quot;Zquot; as well. Thank you for your help.

Assuming your letters are in A1 and numbers in B1, enter this formula
in C1:

=IF(OR(A1lt;gt;quot;Fquot;,B1=0,B1gt;59)quot;Zquot;,IF(AND(A1=quot;Fquot;,B1gt;1,B 1lt;59),quot;yesquot;,quot;not
specifiedquot;)

You don't specify what you want the formula to do if the conditions are
met, so this outputs quot;yesquot;. Your definition of requirements is a bit
loose (eg what happens when B1 = 1, or less than 0?). You don't say
what you want to do when the conditions are not met, so this outputs
quot;not specifiedquot;.

Hope this helps.

PetePete:
In the meantime, prior to getting your post, I wrote the following formula:

=IF(Q4:U4=quot;Fquot;,A4),IF(Q4:U4lt;60,A4),IF(Q4:U4gt;59,quot;Zquot;) ,IF(Q4:U4=0,quot;Zquot;)

Why won't this work? Cells Q-U have either an quot;Fquot;, quot;Dquot; or quot;D-quot; OR a number
from 0-59.

For each cell Q through U, if it is an F, D, D- or number between 1-59, I
want it to refer to the name in column A (in this case A4). If it is a number
less than 1 (0) then I want it to =quot;Zquot;. If it is NOT an F, D or D- or a
number above 59, I also want it to = quot;Zquot;.

Why won't my formula above work. I just tried the one you posted and it is
not working. Thanks so much for your help.

quot;Ikeaglequot; wrote:

gt; I need to write a formula that looks at a set of cells and determines if they
gt; equal quot;Fquot; or if they have numerical value of less than 59 and/or greater than
gt; 1. How would I write this? If quot;Fquot; does not appear in any of the cells, then I
gt; want it to equal quot;Zquot;. If the numerical value is 0 or greater than 59, I want
gt; it to equal quot;Zquot; as well. Thank you for your help.


Where are you putting this formula?

You're looking for 5 results from 5 cells Q4:U4, do you want results in
5 different cells?

This should work for one cell

=IF(ISNUMBER(Q4),IF(OR(Q4=0,Q4gt;59),quot;Zquot;,A4),A4)--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=506058