Formula using If AND OR

I need help with a formula

If F>0 and B is Null show A33

else if

F >0 and B is not null show B33

else if  F33 is null  then ""
leezacAsked:
Who is Participating?
 
etech0Connect With a Mentor Commented:
Try putting this into a cell in row 2, then copying it down.

=if(F2>0,if(B2="",A33,B33),"")
0
 
leezacAuthor Commented:
That works - thanks for fast answer.
0
 
etech0Commented:
Glad I could help! And welcome to nested functions - I think you'll enjoy them!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.