Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please let me know what this formula is supposed to look like In cell F19, enter an IF function using the range names in cells

please let me know what this formula is supposed to look like
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
In cell F19, enter an IF function using the range names in cells E14,E15 and E16 instead of absolute cell references in the formulas. Develop the function to check if the Annual Purchase qualifies for a discount and then calculate the discount amount. (Data is in the range names) HINT: The value in cell F19 should be $1,652.13. Don't forget to fill down the formula using the Fill Handle. f19345678010111213141516171610202122232425252729 +1f Total Anoual Purchase. Discount Amiount Stateenent Credit BasesaleDiscounthateTarpate530,000,003.000%3.250% 30,000.003.000%3.250% \begin{tabular}{|r|l|l|l|l|} \hline \multicolumn{1}{|c|}{ urchase } & Discount Amount & Statement Credit & Invoice Total & Message \\ \hline 555.071 .00 & & & & \\ \hline 28.417 .00 & & & & \\ \hline 513.588 .00 & & & \\ \hline$46.561.00 & & & \\ \hline$984.00 & & & \\ \hline 33,693.00 & & & \\ \hline 42.502 .00 & & & \\ \hline 25,313.00 & & & \\ \hline 550.609 .00 & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

What are the differences among a yeast, a mold, and a mushroom?

Answered: 1 week ago