Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems adding formula together. Please Help!
Hi,
I am ultimately trying to incorporate these two: =ROUND(7/(A3-A3),5) =IF(A30.5,A3,"") I cant get them to both run together though €“ has anyone any suggestions please?? Ted. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems adding formula together. Please Help!
Doesn't the math portion of =ROUND(7/(A3-A3),5) specifically 7/(A3-A3)
result in a "Divide by zero" regardless of the value of A3? I'm not the sharpest knife in the drawer when it comes to Excell ,(I'm looking for help on another matter) so there could be something somewhere else in the formula that invalidates my observation, but I'd start by making sure the math operation is actually what you want done. Adam "Ted" wrote in message ... Hi, I am ultimately trying to incorporate these two: =ROUND(7/(A3-A3),5) =IF(A30.5,A3,"") I cant get them to both run together though - has anyone any suggestions please?? Ted. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems adding formula together. Please Help!
Hi!
=ROUND(7/(A3-A3),5) That won't work. You're dividing by zero and will return a #DIV/0! error. Perhaps you mean: =ROUND(7/A3-A3,5) And perhaps this: =IF(ROUND(7/A3-A3,5)0.5,A3,"") Biff "Ted" wrote in message ... Hi, I am ultimately trying to incorporate these two: =ROUND(7/(A3-A3),5) =IF(A30.5,A3,"") I cant get them to both run together though - has anyone any suggestions please?? Ted. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems adding formula together. Please Help!
Hi, sorry, I meant to write A3-B3 for all of it - its because its for cells
ZX and ZY etc, so I thought it might be simpler to use examples of single alphabet. Otherwise, the formula is fine €“ except for me not being able to attach the two. They work well alone etc, I just dont know what order to separate the sections and what abbreviations to use etc. If anyone has any ideas..? Thanks for you response though, its appreciated. Ted. "Adam Kroger @hotmail.com" wrote: Doesn't the math portion of =ROUND(7/(A3-A3),5) specifically 7/(A3-A3) result in a "Divide by zero" regardless of the value of A3? I'm not the sharpest knife in the drawer when it comes to Excell ,(I'm looking for help on another matter) so there could be something somewhere else in the formula that invalidates my observation, but I'd start by making sure the math operation is actually what you want done. Adam "Ted" wrote in message ... Hi, I am ultimately trying to incorporate these two: =ROUND(7/(A3-A3),5) =IF(A30.5,A3,"") I cant get them to both run together though - has anyone any suggestions please?? Ted. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems adding formula together. Please Help!
the two I am trying to connect to be one sum, should be:
=ROUND(7/(A3-B3),5) =IF(<0.5"") where "" means enter a blank cell sorry for the previous version. any ideas? T. "Adam Kroger @hotmail.com" wrote: Doesn't the math portion of =ROUND(7/(A3-A3),5) specifically 7/(A3-A3) result in a "Divide by zero" regardless of the value of A3? I'm not the sharpest knife in the drawer when it comes to Excell ,(I'm looking for help on another matter) so there could be something somewhere else in the formula that invalidates my observation, but I'd start by making sure the math operation is actually what you want done. Adam "Ted" wrote in message ... Hi, I am ultimately trying to incorporate these two: =ROUND(7/(A3-A3),5) =IF(A30.5,A3,"") I cant get them to both run together though - has anyone any suggestions please?? Ted. |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Problems adding formula together. Please Help!
I assume you do the ROUND function if something is < 0.5. What might that
be, pray tell? "Ted" wrote in message ... the two I am trying to connect to be one sum, should be: =ROUND(7/(A3-B3),5) =IF(<0.5"") where "" means enter a blank cell sorry for the previous version. any ideas? T. "Adam Kroger @hotmail.com" wrote: Doesn't the math portion of =ROUND(7/(A3-A3),5) specifically 7/(A3-A3) result in a "Divide by zero" regardless of the value of A3? I'm not the sharpest knife in the drawer when it comes to Excell ,(I'm looking for help on another matter) so there could be something somewhere else in the formula that invalidates my observation, but I'd start by making sure the math operation is actually what you want done. Adam "Ted" wrote in message ... Hi, I am ultimately trying to incorporate these two: =ROUND(7/(A3-A3),5) =IF(A30.5,A3,"") I cant get them to both run together though - has anyone any suggestions please?? Ted. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Editing an existing formula | Excel Worksheet Functions | |||
Adding columns (one with a formula) | New Users to Excel | |||
Formula help : adding | New Users to Excel | |||
Problems with the VLOOKUP formula | Excel Worksheet Functions | |||
Adding an extra validation to this formula. | Excel Discussion (Misc queries) |