Apr 11 2018 06:21 AM
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
Apr 11 2018 06:27 AM
It is OK thanks. I've worked it out.