Formula using If AND OR

leezac
leezac used Ask the Experts™
on
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 ""
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Try putting this into a cell in row 2, then copying it down.

=if(F2>0,if(B2="",A33,B33),"")

Author

Commented:
That works - thanks for fast answer.

Commented:
Glad I could help! And welcome to nested functions - I think you'll enjoy them!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial