Conditional formatting using formula IF

Copper Contributor

Can anyone please tell me how do I set up a conditional formula so where, for instance, cell A1 = D, Cell A2 will be 15.5, and ahere cell A1= DS, cell A2 will be 15.5 and cell B2 will be 1.

 

Many thanks for your help

1 Reply

It is OK thanks. I've worked it out.