Answered step by step
Verified Expert Solution
Question
1 Approved Answer
please help Function Calculation Amount Formula Formula Work Area ROUND Round to closest dollar 209.78 210 =ROUND(C2,0) ROUNDUP Round up to next dollar 209.78 210
please help
Function | Calculation | Amount | Formula | Formula | Work Area | ||
ROUND | Round to closest dollar | 209.78 | 210 | =ROUND(C2,0) | |||
ROUNDUP | Round up to next dollar | 209.78 | 210 | =ROUNDUP(C3,0) | |||
ROUNDDOWN | Round down to next dollar | 209.78 | 209 | =ROUNDDOWN(C4,0) | |||
ROUND | Round to nearest 100 | 1234 | 1200 | =ROUND(C6,-2) | |||
ROUNDUP | Round up to nearest 100 | 1234 | 1300 | =ROUNDUP(C7,-2) | |||
ROUNDDOWN | Round down to next dollar | 1234 | 1200 | =ROUNDDOWN(C8,-2) | |||
ROUND | Round to nearest 1,000 | 1234 | 1000 | =ROUND(C10,-3) | |||
ROUNDUP | Round up to nearest 1,000 | 1234 | 2000 | =ROUNDUP(C11,-3) | |||
ROUNDDOWN | Round down to nearest 1,000 | 1234 | 1000 | =ROUNDDOWN(C12,-3) | |||
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started