Notifications
Clear all
General Excel Questions & Answers
2
Posts
2
Users
0
Reactions
55
Views
Topic starter
In cell E2, I need a formula that says if the value in B2 is equal to 0 then copy the name from cell A2
And,
in cell G2, I need a formula that says if the value in B2 is equal to 0 then copy the assignment from cell B1
Posted : 11/02/2019 8:11 pm
Hi Janine,
You can learn to use the IF function with these posts
https://www.myonlinetraininghub.com/excel-if-statement-explained
https://www.myonlinetraininghub.com/excel-if-and-or-functions-explained
In E2 you need
=IF(B2=0,A2,"")
and in G2
=IF(B2=0,$B$1,"")
See attached workbook.
Regards
Phil
Posted : 11/02/2019 10:03 pm
