View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.newusers
Roger Govier
 
Posts: n/a
Default 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