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