I can't find why my formula is inconsistant - please help

[Guest]

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

 

[MartinW]

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

 

[Ron Rosenfeld]

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

 

[Ragdyer]

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)
?

 

[Guest]

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.

 

[Guest]

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.

 

[Guest]

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]

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