More Formula Help Please

[Guest]

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

 

[Roger Govier]

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

 

[Bernard Liengme]

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" ......