Decimal Issues

D

Danny

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
 
G

Guest

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.
 
D

Danny

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top