True and false formula

S

susy

Hi my name is susy

I have been using true & false formulas. But every time I use them I get a
! sign argumenting that this formula is different form the other in this
area. this is how I formulated it G100=(F100/1.82)=H100

At the other hand I get a falsE while it should be true using this same
formula G26=(F26)/1.82=H26

1. how can I avoid this?
2. how can I check if the formula have a error?
3. or there are limits for using the ture and false

susy
 
S

susy

thnx for the reply it did help me with the false error because indeed it's a
financial structure/frame I'm working.
But I still get the ! telling me it's a inconsistent formula even after I
used the formula suggested by you.
 
W

Wondering

That simply means means the formula is different from the formulas in the
cell above it and below it or it is different from the formula in the cell
to the left and to the right of it. Example. If C10 contains the formula
=1*10 and C11 contains =1*11 and C12 contains =1*10, C11 will be flagged
with having an inconsistent formula. Likewise if cell B11 contains =1*15 and
cell D11 contains =1*15, C11 with =1*10 will get flagged again as
inconsistent.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top