I already have this formula =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid
Entry"))
I now wish to add if A1=D then B1=the word 'DAY' and C1= the word 'RATE' and
D1=100, can somebody help me YET again...

Thank you

Andy JL

Hi Andy

If I have understood you correctly, then
=IF(AND(A1="D",B1="DAY",C1="RATE",D1=100),"what you want if True","what you
want if False")

Regards

Roger Govier


Andy JL wrote:
I already have this formula =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid
Entry"))
I now wish to add if A1=D then B1=the word 'DAY' and C1= the word 'RATE' and
D1=100, can somebody help me YET again...

Thank you

Andy JL

You need separate IF formulas in B1, C1 and D1 as a formula cannot change
values in cells other than the one it is in - array formulas are 'in' a
range of cells often.
So using what you have learned from your first question, experiment with in
B1 =IF(A1="D" ......

--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Andy JL" wrote in message
...

I already have this formula =IF(A1="M",8,IF(OR(A1="C",A1="V"),2,"Invalid
Entry"))
I now wish to add if A1=D then B1=the word 'DAY' and C1= the word 'RATE'
and
D1=100, can somebody help me YET again...

Thank you

Andy JL