Three things:
-- leave a decimal point followed by two zeroes,
-- round down whether decimal value is below or above .50, and,
-- this is in "currency" format (as probably you've guessed!)
Thank you for your consideration!
MacBook Air (M2, 2023)
Hi sokolik,
Try this:
Formula in C2 is ROUNDDOWN(B2,0)
Columns B and C are formatted as Currency with 2 decimals (the default).
Regards,
Ian.
Hi sokolik,
Try this:
Formula in C2 is ROUNDDOWN(B2,0)
Columns B and C are formatted as Currency with 2 decimals (the default).
Regards,
Ian.
Many thanks! And thank you for the immediate example...I lacked the patience for online videos with lengthy explanations. Again, thanks!
Apple Numbers Round Down to Nearest Whole Number
