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.
=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.