[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 118
  • 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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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