View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default True and false formula

Most likely there are rounding errors, what are you comparing and how much
of a precision do you need? What values are in H? If they are currencies for
example then you might try

=ROUND(F100/1.82,2)=ROUND(H100,2)


--


Regards,


Peo Sjoblom



"susy" wrote in message
...
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