View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Nickie Nickie is offline
external usenet poster
 
Posts: 9
Default Please help on IF formula

I need a formula to produce a true or false result based on if a cell H71
(with a formular similar to this =(G71*$I$1)+G71 matches the figure in
another cell J71

I tried the following but i keep getting a false result even though the
totals of the cells match

=if((H71*$I$1)+H71=J71,"True","false")

G H I J
1 17.5%
..
..
71 21,101.00 24,793.68 24,793.68

Any help much appreciated
--
Regards

Nickie