Refining an IF statement

Folks,
Although I am not getting an error I am getting a zero. See below
Zero removedI would NOT want a zero but instead "".
Frank FreeseAsked:
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.

NorieData ProcessorCommented:
What's actually in O6?
0
Martin LissOlder than dirtCommented:
=AVERAGE(N6:N10) gives 8 like it should.
0
Martin LissOlder than dirtCommented:
Do you still have =IF(OR(O6="",O6=0), " ", IF(O6=8,"Correct","Incorrect")) in P6?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Frank FreeseAuthor 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
NorieData 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

Your issues matter to us.

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

Start your 7-day free trial
Martin LissOlder than dirtCommented:
Well instead of saying O6=8 in that IF statement couldn't you substitute O6=AVERAGE(N6:N10)?
0
Frank FreeseAuthor 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
Frank FreeseAuthor 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.