View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stan Brown Stan Brown is offline
external usenet poster
 
Posts: 524
Default If Statement Not Working

Fri, 11 May 2007 05:27:01 -0700 from Telegirl
:
All the cells are formatted to currency, with two decimal places. And yes, it
does assume that G20 is larger than H20.


Formatting doesn't matter in calculations, unless you've checked
"Precision as displayed" in Tools | Options | Calculation.

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/