=IF problem and function help

  • Thread starter Thread starter kba11
  • Start date Start date
K

kba11

I'am noway near a pro with excel so excuse me clogging up thes
forums/newsgroups.

Is there a "BUT" or "UNLESS" formula in excel

"BUT" representing my made up function

=IF(G8<=$E$1,"YES","NO") BUT =IF(ISNA(G5),"NO","NO")

I want this to go into cell G4.

Heres my problem in words...

I have a vlookup taking data from one sheet to another, where there i
no data for I to carry across i get a #N/A, now when cell G4 is equa
to or greater than cell E1 is says NO, but because the value in th
#N/A cells is allways less than that is allways says yes. But I want i
to say NO.

Complex in my mind but please help if you can in any way,

Thank
 
Kbal,

That is exactly what they are for.

Is this what you mean?

=IF(ISNA(G5),"NO",IF(G8<=$E$1,"YES","NO"))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
YEP that fantastic! sorry i was given the ISNA formula and i dont kno
how it works,and i dont really know too much on excel.


but thank you
 
Back
Top