Re: IF OR Q

=IF(OR(C7="Car",C7="Van",C7="Bike"),D7,"Enter Price")


--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Sean" <seanryanie@xxxxxxxxxxx> wrote in message
news:1170155501.194414.15060@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have the following formula that I wish to return a value for

=IF(OR(C7=Car,Van, Bike),D7,"Enter Price")

Car, Van Bike are values within a Drop down list that I select in Cell
C7 etc

I am getting an error message 'There is more than one Cell with this
label' for Van - what does that mean and how can I overcome it? I
don't have any Range Names with this label.

I've removed Van from my formula i.e. =IF(OR(C7=Car,Bike),D7,"Enter
Price") and when I copy this down past C8 I get
=IF(OR(C7=Car,Car),D7,"Enter Price") - how can "Bike" now change to
"Car"??

Is it because the text I'm looking for are from a dropdown?

Thanks



.

Relevant Pages

  • FA LP Penny Nichols Pennys Arcade Acid Folk
    ... Morrison, Van Astral Weeks Later Issue 4836683908 ... Van His Band & The Street Choir Green Label 4836683999 ... Mud Acres Music Among Friends w/ Maria Muldaur 4836684888 ...
    (rec.music.marketplace.vinyl)
  • FA LP Van Morrison Moondance W7 Label 1 Cent Min Bid No Reserves
    ... To view Van Morrison Moondance Green W7 Label go to: ... Mitchell, ...
    (rec.music.marketplace.vinyl)
  • FA LP Van Morrison Tupelo Honey Green Label with Poster
    ... To view Van Morrison Tupelo Honey Green Label with Poster go to: ... Michael Pretty Much Your Standard Ranch Stash 4789614130 ...
    (rec.music.marketplace.vinyl)
  • IF OR Q
    ... Van Bike are values within a Drop down list that I select in Cell ... label' for Van - what does that mean and how can I overcome it? ...
    (microsoft.public.excel.worksheet.functions)
  • Re: IF OR Q
    ... (there's no email, no snail mail, but somewhere should be gmail in my addy) ... label' for Van - what does that mean and how can I overcome it? ...
    (microsoft.public.excel.worksheet.functions)