Home

Conditional formatting using formula IF

Barry Druce
New 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.

Related Conversations
Help with an IF AND formula
aanaya6 in Excel on
3 Replies
IF FUNCTION ISN'T WORKING NO MATTER HOW SIMPLE THE COMMAND IS
thomasea in Excel on
6 Replies
formula for data calculation
aayushman_mishra in Excel on
10 Replies
Creating A Sublist
zjohnson in Excel on
5 Replies
Excel Forumla to exclude empty cells.
ulken2019 in Excel on
6 Replies