Hi,
I need help modifying my formula to work. I'm trying to have the value of Cell B2 based off the combination value of two other cells.
Please Login or Register to view this content.
Hi,
I need help modifying my formula to work. I'm trying to have the value of Cell B2 based off the combination value of two other cells.
Please Login or Register to view this content.
hi there kosherboy. your formula does not work at the moment, so it's better to describe to us in words. so if A1 is "Yellow" and A2 is "Blue", you want to show B2 as "Green"? Otherwise, show it as a blank? if so,
=IF(AND(A1="Yellow",A2="Blue"),"Green","")
Thanks, if you have clicked on the * and added our rep.
If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".
"Contentment is not the fulfillment of what you want, but the realization of what you already have."
Tips & Tutorials I Compiled | How to Get Quick & Good Answers
Thx, your formula worked perfectly!
thanks to you I now have a broader understanding in formulas
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks