Put " marks around DAY

If (A1="D","DAY", <whatever)

Adam

"Andy JL" wrote in message
...
Bernard,
To your formula below I want to add if A1=D then it = the word "DAY", I
have
been trying allways but can not get it to enter the word"DAY" even if i
cut
the formula down to If (A1="D",DAY ....... I can do it with a number
instead
of the "DAY" but I can not put it in to you formula. I think I have
expalinded myself!!!

Thanbk you

Andy JL

"bernard liengme" wrote:

Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,""))
If A1 is not M,C or V you get a blank
Use =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,0))
If A1 is not M,C or V you get a zero
Not case sensitive
best wishes
Bernard

"Andy JL" wrote in message
...
Hi.

I want a formula to enter into a cell - if A1 is "M" then I want C1 to
be
£8.00 or
if A1 is "C or V" then I want C1 to be £2.00. Is there a formula that I
can
enter in Cell C1 to make display either £2.00 or £8.00 depending on wat
is
in
A1 -

Thanks for any help

Andy JL