Need help with formula if multiple cells are empty then another [Closed]

Report
Posts
2
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
October 28, 2014
-
Posts
2
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
October 28, 2014
-
I am using excel 2010, I need help with a formula that i can t seem to get i know i am close. example. A1,B1,C1,D1 - if B1 is blank and C1 is blank then i want D1 to equal A1. But if there is text in B1 or C1 then I want D1 to be that value. Any help would be greatly appreciated.

Cheers, Trevor

2 replies

Posts
2693
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 18, 2021
455
Hi Trevor34,

So if C1 has a value, D1 should take that value.
If C1 is empty, see if B1 has a value to take D1's place, if not then take a look at A1.

Try this formula in D1:
=IF(C1<>"",C1,IF(B1<>"",B1,A1))


Best regards,
Trowa
Monday, Tuesday and Thursday are usually the days I'll respond. Bear this in mind when awaiting a reply.
Posts
2
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
October 28, 2014

=IF(B1&C1&D1="",A1,B1&C1&D1) I actually Played around with it for sometime and came up with this and it seems to be pulling what data I am looking for. Thank so much for the quick reply though. I am going to copy and give yours a try though. I will get back to you.

Much appreciated! Trevor.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!