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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help on IF formula
False is correct because they do not match. Your calculation in H71 is
24,793.675 and your display is to 2 dp so shows 24,793.68 I assume you have manually typed in J71 Try =IF(TEXT(H71,"######.##")=TEXT(J71,"######.##"),"T rue","False") "Nickie" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help on IF formula
Thank you very much Dennis that worked, it is greatly appreciated
-- Regards Nickie "Dennis" wrote: False is correct because they do not match. Your calculation in H71 is 24,793.675 and your display is to 2 dp so shows 24,793.68 I assume you have manually typed in J71 Try =IF(TEXT(H71,"######.##")=TEXT(J71,"######.##"),"T rue","False") "Nickie" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help on IF formula
Try
=ROUND(H71*(1+$I$1),2)=J71 -- __________________________________ HTH Bob "Dennis" wrote in message ... False is correct because they do not match. Your calculation in H71 is 24,793.675 and your display is to 2 dp so shows 24,793.68 I assume you have manually typed in J71 Try =IF(TEXT(H71,"######.##")=TEXT(J71,"######.##"),"T rue","False") "Nickie" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help on IF formula
Another alternative is to try ROUNDUP on your calculation
=ROUNDUP((G71*$I$1)+G71),2) then your original check for true or false should work "Nickie" wrote: Thank you very much Dennis that worked, it is greatly appreciated -- Regards Nickie "Dennis" wrote: False is correct because they do not match. Your calculation in H71 is 24,793.675 and your display is to 2 dp so shows 24,793.68 I assume you have manually typed in J71 Try =IF(TEXT(H71,"######.##")=TEXT(J71,"######.##"),"T rue","False") "Nickie" wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Please help on IF formula
I meant ROUND on my last post not ROUNDUP
"Nickie" wrote: Thank you very much Dennis that worked, it is greatly appreciated -- Regards Nickie "Dennis" wrote: False is correct because they do not match. Your calculation in H71 is 24,793.675 and your display is to 2 dp so shows 24,793.68 I assume you have manually typed in J71 Try =IF(TEXT(H71,"######.##")=TEXT(J71,"######.##"),"T rue","False") "Nickie" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|