• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 267
  • Last Modified:

IF Statement in Excel

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
babychango
Asked:
babychango
1 Solution
 
nutschCommented:
use N() function

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

Thomas
0
 
babychangoAuthor Commented:
Excellent!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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