Question
Please provide a step by step solution that would give me a result in 0 for cell B30 please note that b29=NO the amount in
Please provide a step by step solution that would give me a result in 0 for cell B30
please note that b29=NO the amount in B14 is 83,227 and they want to know if its greater than 125,000 which result in b29 result to NO
1.In cell B29, insert a formula with an IF statement that returns Yes if the total San Francisco sales 83,227 for the month of January is greater than or Equal to the Sales Quota of $125,000.If Sales is not greater than $125,000, insert the word No.Use absolute addressing in your formula.
In cell B30, insert a formula with an IF statement. If B29 is Yes, multiply the amount in B14 by 2%. If B29 is No, insert a zero. Use absolute addressing in your formula.
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