View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Susy Susy is offline
external usenet poster
 
Posts: 21
Default True and false formula

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