[Webinar] Streamline your web hosting managementRegister Today

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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering 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