Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi Guys, I have this formula =IF(G22="","",(H22+I22)*G22) What I use it
for is to add two different prices together then they get multiplied by the amount entered into a cell. eg, H22=$2.24, I22=$0.52 and if I enter 1 into G22 it equals $2.76, which is correct. But if I enter a figue of 1800 into G22 I get a figue of $4961.42 when it should be $4968.00. Any help for this novice would be great. Thanks |
#2
![]() |
|||
|
|||
![]()
Are the values in H22 and I22 the results of formulas? If so its probably a
rounding issue where for example 2.236458 is displayed as 2.24 but the actual value is still 2.236458, try =IF(G22="","",ROUND((H22+I22),2)*G22) Regards, Alan. "Eintsein_mc2" wrote in message oups.com... Hi Guys, I have this formula =IF(G22="","",(H22+I22)*G22) What I use it for is to add two different prices together then they get multiplied by the amount entered into a cell. eg, H22=$2.24, I22=$0.52 and if I enter 1 into G22 it equals $2.76, which is correct. But if I enter a figue of 1800 into G22 I get a figue of $4961.42 when it should be $4968.00. Any help for this novice would be great. Thanks |
#3
![]() |
|||
|
|||
![]()
Thanks Alan, you are right they are the results of formulas. Before I
asked for help I tried adding "ROUND" to the fomula but could not get it to work. After looking at your formula I know why, Thanks for your help. Regards, Simon |
#4
![]() |
|||
|
|||
![]()
Your welcome, BTW it can be simplified to
=IF(G22="","",ROUND(H22+I22,2)*G22) Regards, Alan. "Eintsein_mc2" wrote in message oups.com... Thanks Alan, you are right they are the results of formulas. Before I asked for help I tried adding "ROUND" to the fomula but could not get it to work. After looking at your formula I know why, Thanks for your help. Regards, Simon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem with formula in Excel | Excel Worksheet Functions | |||
problem with Array Formula | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Problem with formula | Excel Discussion (Misc queries) | |||
Need a formula for this problem | Excel Worksheet Functions |