Help with ROUNDDOWN FUNCTION

[Khaldon]

=IF($H$8="","",IF(Q8<O8,Q8-D9-D11-E8-G8,IF(Q8>O8,Q8-D11-E8-G8,Q8-D9-D11-E8-G8)))

The result of the above formula was 314.75, using cell formate of one decimal spaces rounded up the resulting number to 314.8.

How can I please modify the above formula to round downward the number instead of upward to have a result of of this formula 314.7 with one decimal formatting instead of 314.8?

[cbatrody]

Hi,

I have modified your formula as following, please check if it works:


=IF($H$8="","",IF(Q8<O8,ROUND(Q8-D9-D11-E8-G8,1),IF(Q8>O8,ROUND(Q8-D11-E8-G8,1),ROUND(Q8-D9-D11-E8-G8,1))))


Regards,
Chandra

Please click on ‘ * Add Reputation’ button on the left side bottom of my post if I was helpful in resolving the issue.

[cbatrody]

& Use the following formula in the next column next to the output column (refer the excel sheet attached).

=INT(K8)+((1*(MID(K8-INT(K8),3,1)))/10)

[martindwilson]

you can shorten that
=IF(H8="","",ROUNDDOWN(Q8-D11-E8-G8-IF(Q8<=O8,D9,0),1))

[Khaldon]

Cbatrody Unfortunately I am still getting 314.8 as a final result.

Martindwilson, thank you for the shorting but again I am still getting 314.8 as result instead of the desire 314.7 result!!

[cbatrody]

Did you use the following formula in the next column of the result?


=INT(K8)+((1*(MID(K8-INT(K8),3,1)))/10)

Please refer the attached excel sheet.

[cbatrody]

If you are still unable to get the desired result, please upload your excel workbook. I will make the changes and post it back for you.

[Khaldon]

I am sorry I am unable to load all the workbook it is to private and hard to sample.

[cbatrody]

Did you go through the Book11 i had uploaded?

[martindwilson]

=rounddown(314.75,1) = 314.7

[Khaldon]

Yes, but to be honest with you I could not apply it to my formula and end up with the desire result.

[cbatrody]

Did you not try the formula (ROUNDDOWN) martindwilson had given?

What about the following?

=IF($H$8="","",IF(Q8<O8,ROUNDDOWN(Q8-D9-D11-E8-G8,1),IF(Q8>O8,ROUNDDOWN(Q8-D11-E8-G8,1),ROUNDDOWN(Q8-D9-D11-E8-G8,1))))

Regards,
Chandra

[Khaldon]

Is it possible please to replace ROUNDDOWN Function with ROUND Function only and still accomplish the same last formula result?

Best regards

[Khaldon]

Your last formula is fine but unfortunately the apple app I am using to work with my Excel Sheet dose not support the function ROUNDUP and ROUNDDOWN.

Is there another way please to accomplish the same result using ROUND function or any other function and end up with the same desired result.

[martindwilson]

well its not excel you are using then....what are you using ?no point anyone giving solutions unless they know what functions ARE available to you

[bebo021999]

How about:
=ROUND("Your formula",1)-0.1

[martindwilson]

can you use floor and ceiling?
=FLOOR(A1,0.1)
=CEILING(A1,0.1)

[Khaldon]

I am sorry I missed that, below is a link that contains all the functions available to my app.

http://support.dataviz.com/support.srch?docid=2310

[Khaldon]

The =ROUND("my formula",1)-0.1 works fine except for the result that end with zero, it should remain as it is, like 314.70, the result should stay as it is 314.70 with no rounding down please.

The suggested formula is rounding the number to 314.60!!

[Khaldon]

=ROUND("My formula",1)-0.1

The above formula is working fine with me, the only issue is when my original formula result in a number end with decimal number and zero. The above formula then round down the last two decimal numbers!!

Example:
My Original formula result is 314.75, it will be round down to 314.70 and that is ok.
But if my formula resulted in 314.70, the formula above is rounding down my formula result to 314.60 and that is not ok.

If my original formula resulted in a number that end up with a decimal number followed by zero, I would like it please to stay as it is.

Example:
314.70 should remain 314.70.

Can you please modify the above formula using ROUND function or any other functions available from the link below to accomplish my desire result above?

http://support.dataviz.com/support.srch?docid=2310

Regards,