Need help with formula if multiple cells are empty then another

Closed
trevor34 Posts 2 Registration date Tuesday October 28, 2014 Status Member Last seen October 28, 2014 - Oct 28, 2014 at 11:08 AM
trevor34 Posts 2 Registration date Tuesday October 28, 2014 Status Member Last seen October 28, 2014 - Oct 28, 2014 at 01:03 PM
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

TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Oct 28, 2014 at 12:36 PM
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.
0
trevor34 Posts 2 Registration date Tuesday October 28, 2014 Status Member Last seen October 28, 2014
Oct 28, 2014 at 01:03 PM
=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.
0