Solved

# IF Statement in Excel

Posted on 2012-09-18
Medium Priority
262 Views
I am using the following formula:
=IF(E3=0," ",IF(C2<>C3,1,F2+1))

The problem is when cell F2 is blank I get an error (#VALUE)
How do I get the formula to consider blank as a 0 so it can solve F2+1 as being 1
Any ideas on how I can fix this formula?

(I don't want to replace blank values by 0)
0
Question by:babychango

LVL 39

Accepted Solution

nutsch earned 2000 total points
ID: 38410768
use N() function

=IF(E3=0," ",IF(C2<>C3,1,N(F2)+1))

Thomas
0

Author Closing Comment

ID: 38410883
Excellent!
0

## Featured Post

Question has a verified solution.

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

How to get Spreadsheet Compare 2016 working with the 64 bit version of Office 2016
If you need to forecast numbers -- typically for finance -- the Windows and Mac versions of Excel 2016 have a basket of tools to get the job done.
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabilâ€¦
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
###### Suggested Courses
Course of the Month15 days, 10 hours left to enroll