More Formula Help Please
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
|