Solved

What IF function

Posted on 2014-11-27
2
73 Views
Last Modified: 2014-11-27
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
Comment
Question by:robmarr700
2 Comments
 
LVL 27

Accepted Solution

by:
MacroShadow earned 500 total points
ID: 40468889
Use this formula:
=IF(A1+B1<1,0,1)
0
 

Author Comment

by:robmarr700
ID: 40468901
That's great thank-you!

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

Rob
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question