Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal Issues
I am using the following formula: =("Cost per Unit
="&SUMIF(G26:G44,"yes",N26:G44) I have also used the same formula, but using sum instead of sumif. In all case the resultant value varies in decimal places. The above formula yieds 14 decimal places. In the formulas using SUM only, the decimal places vary. I checked the summed range and all the cells are set to zero decimal places. I have also tried formatting the cell. Interestinly, the value shows in the header, but changing the number of decimals does not affect the result. Thanks in advance, Danny |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal Issues
Hi
Formatting the cell will make no difference because the formula gives you text as a result. Try this: ="Cost per Unit ="&TEXT(SUMIF(G26:G44,"yes",N26:G44),"0.00") for two decimal places etc. Hope this helps. Andy. "Danny" wrote in message ... I am using the following formula: =("Cost per Unit ="&SUMIF(G26:G44,"yes",N26:G44) I have also used the same formula, but using sum instead of sumif. In all case the resultant value varies in decimal places. The above formula yieds 14 decimal places. In the formulas using SUM only, the decimal places vary. I checked the summed range and all the cells are set to zero decimal places. I have also tried formatting the cell. Interestinly, the value shows in the header, but changing the number of decimals does not affect the result. Thanks in advance, Danny |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal Issues
Andy,
Hello You nailed it, Thanks! and thanks for the quick response. I'll have to write this down as it is one for the memory, but the memory sometimes needs help! Danny "Andy" wrote: Hi Formatting the cell will make no difference because the formula gives you text as a result. Try this: ="Cost per Unit ="&TEXT(SUMIF(G26:G44,"yes",N26:G44),"0.00") for two decimal places etc. Hope this helps. Andy. "Danny" wrote in message ... I am using the following formula: =("Cost per Unit ="&SUMIF(G26:G44,"yes",N26:G44) I have also used the same formula, but using sum instead of sumif. In all case the resultant value varies in decimal places. The above formula yieds 14 decimal places. In the formulas using SUM only, the decimal places vary. I checked the summed range and all the cells are set to zero decimal places. I have also tried formatting the cell. Interestinly, the value shows in the header, but changing the number of decimals does not affect the result. Thanks in advance, Danny |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Decimal Issues
I know the feeling! Thanks for the feedback.
Andy. "Danny" wrote in message ... Andy, Hello You nailed it, Thanks! and thanks for the quick response. I'll have to write this down as it is one for the memory, but the memory sometimes needs help! Danny "Andy" wrote: Hi Formatting the cell will make no difference because the formula gives you text as a result. Try this: ="Cost per Unit ="&TEXT(SUMIF(G26:G44,"yes",N26:G44),"0.00") for two decimal places etc. Hope this helps. Andy. "Danny" wrote in message ... I am using the following formula: =("Cost per Unit ="&SUMIF(G26:G44,"yes",N26:G44) I have also used the same formula, but using sum instead of sumif. In all case the resultant value varies in decimal places. The above formula yieds 14 decimal places. In the formulas using SUM only, the decimal places vary. I checked the summed range and all the cells are set to zero decimal places. I have also tried formatting the cell. Interestinly, the value shows in the header, but changing the number of decimals does not affect the result. Thanks in advance, Danny |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for: Format Decimal places? | Excel Discussion (Misc queries) | |||
h:mm to decimal value | Excel Discussion (Misc queries) | |||
FIXED 2 DECIMAL PLACES, MUST ENTER ALL ZEROES AFTER DECIMAL POINT. | Excel Discussion (Misc queries) | |||
How do I override fixed decimal place settings in EXcel 2003? | Excel Worksheet Functions | |||
decimal point override does not work | Excel Discussion (Misc queries) |