Solved Multiple If Statement Check

January 4, 2013 at 08:14:14
Specs: Windows 7

Hi

Col O,R,S.T have "0" or an email address down to row 2500

How can I get it to check in Col U if there is an email address in the above cols and if it does return the email address in U

Many thanks


See More: Multiple If Statement Check

Report •


#1
January 4, 2013 at 08:55:42
✔ Best Answer

Assuming only one cell in O, R, S or T will contain an email address, just check each cell for "not equal to 0".

=IF(O3<>0,O3,IF(R3<>0,R3,IF(S3<>0,S3,IF(T3<>0,T3,""))))

If more than one cell might contain an email address, you'll only get the first one.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
January 4, 2013 at 09:51:21

1000000% Brilliant Thanks

Report •

Related Solutions


Ask Question