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

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 "".
0
Frank Freese
Asked:
Frank Freese
  • 3
  • 3
  • 2
2 Solutions
 
NorieCommented:
What's actually in O6?
0
 
Martin LissRetired ProgrammerCommented:
=AVERAGE(N6:N10) gives 8 like it should.
0
 
Martin LissRetired ProgrammerCommented:
Do you still have =IF(OR(O6="",O6=0), " ", IF(O6=8,"Correct","Incorrect")) in P6?
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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
 
NorieCommented:
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
 
Martin LissRetired ProgrammerCommented:
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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

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