Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Unwanted rounding of whole numbers

IF(L4≥I4,I4×H4)+IF(L4≤G4,−G4×F4)


I'm trying to create an IF/Then formula whereby the number in L4 triggers a calculation if L4 is greater than I4 or less than G4.

The formula works well except that the calculation is rounded to the nearest hundred. As I have it now I4xH4= $99.00 but it is displayed as $100.00. G4xF4=$-198.00 but it is displayed as $-200.00.

It seems as though it has to do with the fact that I4 and G4 are numbers derived from a formula. When I use a different cell other than I4 or G4 that is not derived from a formula the result is not rounded.


I have made sure I have enough space in the cell to display the number and have the column set to Currency with 2 decimal spaces.


Any suggestions?

Posted on Mar 12, 2018 9:38 AM

Reply
4 replies

There are no replies.

Unwanted rounding of whole numbers

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple ID.