Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

Formula help

=IF(B7<5,"Yes","No")

Please can you help me amend the formula so that if B7is blank = "" the formula will also return a result of blank.

However should B7 be greater than 5 (<5) it will return "No"
Less than or equal to 5 "Yes"

0
Gazza83
Asked:
Gazza83
  • 2
3 Solutions
 
HainKurtSr. System AnalystCommented:
try

=if(B7="","",IF(B7<5,"Yes","No"))

0
 
jppintoCommented:
"should B7 be greater than 5 (<5)"  ...did you meant "greater than 5 (>5)"?
0
 
cyberkiwiCommented:
However should B7 be greater than 5 (<5) it will return "No"
Less than or equal to 5 "Yes"

Those two put together mean that you have your condition wrong. It's <=5 not <5

=IF(B7="","",IF(B7<=5,"Yes","No"))
0
 
HainKurtSr. System AnalystCommented:
he has this currently

=IF(B7<5,"Yes","No")

and we assume it is correct :) no matter what he put in sentence :)
and he wants "" if B7 is blank + current logic o/w
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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.

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