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?