I have the formula of

=IF(ISBLANK(D18),"",IF(E18="unknown","",(IF(ISBLANK(C18),(F18),(PRODUCT(C18,F18))))))

and I am getting an inconsistant formula error message.

C18 is the quantity code
D18 is where an item catalogue code would go
E18 is where the item description would be displayed (as is set to display
unknown if the code is unrecognised)
F18 is the unit price

Can anyone give me a direction as to why the formula seems to be working
correctly, but is returning an error of an inconsistant formula.

thanks

Hi Kath,

The inconsistant formula error just means that it is inconsistant
with the adjacent cells. I suppose someone might find this
(feature??) handy, I just find it a pain in the a##.

Either turn of error checking all together or just turn of
that particular option in error checking.

HTH
Martin

On Sat, 15 Jul 2006 23:59:02 -0700, Kath <(E-Mail Removed)>
wrote:

>I have the formula of
>
>=IF(ISBLANK(D18),"",IF(E18="unknown","",(IF(ISBLANK(C18),(F18),(PRODUCT(C18,F18))))))
>
>and I am getting an inconsistant formula error message.
>
>C18 is the quantity code
>D18 is where an item catalogue code would go
>E18 is where the item description would be displayed (as is set to display
>unknown if the code is unrecognised)
>F18 is the unit price
>
>Can anyone give me a direction as to why the formula seems to be working
>correctly, but is returning an error of an inconsistant formula.
>
>thanks

What "formula error" message are you getting?
What are the inputs when you get that message?


--ron

I don't quite follow all your arguments in your formula, but, does this work
any better for you:

=IF(OR(ISBLANK(C18),ISBLANK(D18),E18="unknown",ISBLANK(F18)),"",C18*F18)
?
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Kath" <(E-Mail Removed)> wrote in message
news:8D4C531F-8B51-41EF-8243-(E-Mail Removed)...
> I have the formula of
>
>
=IF(ISBLANK(D18),"",IF(E18="unknown","",(IF(ISBLANK(C18),(F18),(PRODUCT(C18,
F18))))))
>
> and I am getting an inconsistant formula error message.
>
> C18 is the quantity code
> D18 is where an item catalogue code would go
> E18 is where the item description would be displayed (as is set to display
> unknown if the code is unrecognised)
> F18 is the unit price
>
> Can anyone give me a direction as to why the formula seems to be working
> correctly, but is returning an error of an inconsistant formula.
>
> thanks

thanks Ragdyer - no that formula doesnt seem to work - the formula I have
works fine, but being new to excel, I didnt understand what the inconsistant
formula alert thingy meant, which MartinW explained. Thanks though - I
appreciate it.

"Ragdyer" wrote:

> I don't quite follow all your arguments in your formula, but, does this work
> any better for you:
>
> =IF(OR(ISBLANK(C18),ISBLANK(D18),E18="unknown",ISBLANK(F18)),"",C18*F18)
> ?
> --
> HTH,
>
> RD
>
> ---------------------------------------------------------------------------
> Please keep all correspondence within the NewsGroup, so all may benefit !
> ---------------------------------------------------------------------------
> "Kath" <(E-Mail Removed)> wrote in message
> news:8D4C531F-8B51-41EF-8243-(E-Mail Removed)...
> > I have the formula of
> >
> >
> =IF(ISBLANK(D18),"",IF(E18="unknown","",(IF(ISBLANK(C18),(F18),(PRODUCT(C18,
> F18))))))
> >
> > and I am getting an inconsistant formula error message.
> >
> > C18 is the quantity code
> > D18 is where an item catalogue code would go
> > E18 is where the item description would be displayed (as is set to display
> > unknown if the code is unrecognised)
> > F18 is the unit price
> >
> > Can anyone give me a direction as to why the formula seems to be working
> > correctly, but is returning an error of an inconsistant formula.
> >
> > thanks
>
>

Hi Ron - I wasnt actually getting any error message as such - the formula was
working as I wanted it to, but being new to Excel, I didnt realise what
inconsistant formula meant, but now I do. Thanks for your help though - I
appreciate it.

"Ron Rosenfeld" wrote:

> On Sat, 15 Jul 2006 23:59:02 -0700, Kath <(E-Mail Removed)>
> wrote:
>
> >I have the formula of
> >
> >=IF(ISBLANK(D18),"",IF(E18="unknown","",(IF(ISBLANK(C18),(F18),(PRODUCT(C18,F18))))))
> >
> >and I am getting an inconsistant formula error message.
> >
> >C18 is the quantity code
> >D18 is where an item catalogue code would go
> >E18 is where the item description would be displayed (as is set to display
> >unknown if the code is unrecognised)
> >F18 is the unit price
> >
> >Can anyone give me a direction as to why the formula seems to be working
> >correctly, but is returning an error of an inconsistant formula.
> >
> >thanks
>
> What "formula error" message are you getting?
> What are the inputs when you get that message?
>
>
> --ron
>

MartinW - Thank you very much - I am not yet completely familiar with Excel,
so I thought there was a bigger error than just "this cell has a different
formula to my neighbouring cell". I shall have to remember that in future.
Thank you very much for your help. I appreciate it.

"MartinW" wrote:

> Hi Kath,
>
> The inconsistant formula error just means that it is inconsistant
> with the adjacent cells. I suppose someone might find this
> (feature??) handy, I just find it a pain in the a##.
>
> Either turn of error checking all together or just turn of
> that particular option in error checking.
>
> HTH
> Martin
>
>
>

You're welcome Kath,

This sort of (helpful??) programming is rampant in Excel.
Personally I would like to get a hold of the programmers
responsible and teach them a few realities of life that they
seem to be missing.

Then again perhaps it is better that we don't meet!
A long jail sentence doesn't sound like much fun!

Regards
Martin