# Refining an IF statement

Folks,
Although I am not getting an error I am getting a zero. See below
I would NOT want a zero but instead "".
###### Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Data ProcessorCommented:
What's actually in O6?
0
Older than dirtCommented:
=AVERAGE(N6:N10) gives 8 like it should.
0
Older than dirtCommented:
Do you still have =IF(OR(O6="",O6=0), " ", IF(O6=8,"Correct","Incorrect")) in P6?
0
Author Commented:
Do you still have =IF(OR(O6="",O6=0), " ", IF(O6=8,"Correct","Incorrect")) in P6?
Not in this example. I'm trying to replace it with a different IF statement. I'm now see the value in allowing the user to enter their own data and do the calculation rather than using my data. The only problem I am having in the IF statement I have introduced is it is returning a zero in P6 even though there is no formula in O6 (the formula is in O6 imnorie).
0
Data ProcessorCommented:
If there's no formula in O6 your formula will return 0.

Perhaps you should try something other than IFERROR?

=IF(ISERROR(O6), "Error - See Remarks", IF(O6="", "", O6))
0

Experts Exchange Solution brought to you by

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Older than dirtCommented:
Well instead of saying O6=8 in that IF statement couldn't you substitute O6=AVERAGE(N6:N10)?
0
Author Commented:
imnorie,
the only change I made was to delete the last O6 and replace it with ""
I am not having a good day - I got hung up on IFERROR and for about ISERROR
good job!
Martin,
imnorie nailed it! But thanks anyway
0
Author Commented:
thanks folks
I gave points to all that helped me.
0
###### It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.