• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 119
  • Last Modified:

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....
0
leezac
Asked:
leezac
1 Solution
 
Rgonzo1971Commented:
HI,

pls try

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

Open in new window

Regards
0
 
Santosh GuptaCommented:
pls try this

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

Open in new window


also some confusion in cell addresses, pls write address in Capital.
0
 
Naresh PatelTraderCommented:
Try this
IF(F5=0,"",IF(AND(F5<>"",OR(I5="yes",I5="no")),A5,""))
0
 
leezacAuthor 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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now