Formual for using and or

I need a formula that will do the following.

If F5 =0," "

else if

If F5 is not null  and I5 = "yes" ,  value from A5 should be entered

else if

if F5 is not null and IF = "no", value from A5 should be entered.

Note:  same values just different scenarios....
Asked:
Who is Participating?

Commented:
pls try this

``````=IF(F5=0,"",IF(AND(F5>0,I5="yes"),F5,IF(AND(F5>0,I5="no"),F5)))
``````

also some confusion in cell addresses, pls write address in Capital.
0

Commented:
HI,

pls try

``````=IF(F5=0;"";IF(OR(I5="yes",I5="no"),A5,""))
``````
Regards
0

TraderCommented:
Try this
IF(F5=0,"",IF(AND(F5<>"",OR(I5="yes",I5="no")),A5,""))
0

Author Commented:
we are still testing.... so far so good
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.

Already a member? Login.

All Courses

From novice to tech pro — start learning today.