IF/OR formula

H

hmm

I have this formula in a cell:

=IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a")

I also want to apply this formula to the same cell:

=IF(F71="XL","--","")

Both formulas work independently, but the first one is for if NUMBERS
are entered in column F and the second formula is for if specific TEXT
is entered in column F. How could I combine these two formulas? I think
I need to have the formula first identify the type of contents in column
F in order for this to work...?

Thanks.
 
A

A.W.J. Ales

Would
=IF(ISNUMBER(H71),IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a"),IF(F71="XL","--"
,""))

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
M

macropod

Hi,

Try:
=IF(F71="XL","--",IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a"))
or
=IF(H71>0.99,(K71/RIGHT(F71,3))/H71,IF(F71="XL","--",""))
or
=IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a")&IF(F71="XL","--","")
depending on how you want the ned result to appear. Try each version to see
which one give the results you want.

Cheers
 
T

Trevor Shuttleworth

Use ISNUMBER or ISTEXT to determine the format of the cell. So, something
like:

=IF(ISTEXT(F71),IF(F71="XL","--",""),IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a
"))

Regards

Trevor
 
H

hmm

Thanks everyone for taking the time to respond. Y'know, newsgroups are the best
part of the internet , the way it was meant to be used-- these groups really
balance out all the pop-up adds, viruses, porn emails and other crap the web
has brought into our lives!

Anyway, macropod's first formula was the one that worked under all conditions:
=IF(F71="XL","--",IF(H71>0.99,(K71/RIGHT(F71,3))/H71,"n/a"))

Thanks again for the help, everyone.
 
Top