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

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

What IF function

I need a formula which returns the following result;

If cell A1 + B1 is less than 1 return "0", if A1+B1 is equal to or greater than 1 return "1"
0
robmarr700
Asked:
robmarr700
1 Solution
 
MacroShadowCommented:
Use this formula:
=IF(A1+B1<1,0,1)
0
 
robmarr700Author Commented:
That's great thank-you!

I've got an interesting question coming up you may be interested in.....

Rob
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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