Question
I need help on creating a formula in excel. In TOTAL 78.42 $1,254.67 80.50 $ - $1,254.67 I need cell E to calculate any thing
I need help on creating a formula in excel. In
| TOTAL | 78.42 | $1,254.67 | 80.50 | $ - | $1,254.67 |
I need cell E to calculate any thing over 80 in cell D and multiply the overage by another cell in the worksheet to give me a total in cell F
I need whatever E is (number) needs to multiply a dollar amount and can not be rounded in cell F
Step by Step Solution
3.49 Rating (149 Votes )
There are 3 Steps involved in it
Step: 1
IFD4G4D4G4H40 ...
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
Systems analysis and design
Authors: kenneth e. kendall, julie e. kendall
8th Edition
135094909, 013608916X, 9780135094907, 978-0136089162
