Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |