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

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

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

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

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

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