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
trevor34 Posts 2 Registration date Tuesday October 28, 2014 Status Member Last seen October 28, 2014 - Oct 28, 2014 at 01:03 PM
Related:
- Need help with formula if multiple cells are empty then another
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Number to words in excel formula - Guide
- Excel grade formula - Guide
- Credit summation formula - Guide
- Date formula in excel dd/mm/yyyy - Guide
2 responses
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Oct 28, 2014 at 12:36 PM
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.
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.
trevor34
Posts
2
Registration date
Tuesday October 28, 2014
Status
Member
Last seen
October 28, 2014
Oct 28, 2014 at 01:03 PM
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.
Much appreciated! Trevor.
