SOLVED

"If/than" statements

New Contributor

Excel

 

Trying to learn- this is probably pretty simple! I am attempting an "If/than" statement in conditional formatting. The attached document is ran from a report in a medical database. Goals: 

- If column R (route) has a cell = 0 I want that row's column T to automatically populate the number "2". 

- If column R has a number in it I want that row in column T to remain blank. 

2 Replies
best response confirmed by OKaullen (New Contributor)
Solution
I believe the formula =IF(R2=0,"2","") will work.
Thank you so much! Works perfectly!