Solved

Refining an IF statement

Posted on 2014-07-10
88 Views
Folks,
Although I am not getting an error I am getting a zero. See below
I would NOT want a zero but instead "".
0
Question by:Frank Freese

LVL 33

Expert Comment

What's actually in O6?
0

LVL 44

Expert Comment

=AVERAGE(N6:N10) gives 8 like it should.
0

LVL 44

Assisted Solution

Do you still have =IF(OR(O6="",O6=0), " ", IF(O6=8,"Correct","Incorrect")) in P6?
0

Author Comment

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

LVL 33

Accepted Solution

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

LVL 44

Expert Comment

Well instead of saying O6=8 in that IF statement couldn't you substitute O6=AVERAGE(N6:N10)?
0

Author Comment

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 Closing Comment

thanks folks
I gave points to all that helped me.
0

Featured Post

INDEX and MATCH can be used to great effect to replace HLOOKUP and VLOOKUP as it does not have the limitation of needing the data to be sorted so that the reference value is in the first column or row. It also has the ability to perform a bi-directi…
Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.