Answered step by step
Verified Expert Solution
Question
1 Approved Answer
MS EXCEL WHAT IF ANALYSIS HELP Create a calculation to determine the amount of the donation matched. Remember if the organization is a nonprofit AND
MS EXCEL WHAT IF ANALYSIS HELP
Create a calculation to determine the amount of the donation matched.
Remember if the organization is a nonprofit AND the donation is less than $500, Lazarus will match the 50% of the donation up to $500. If it does not fit this criteria, then the matched amount will be $0.
- I have yes/no for non profit in column E and total donation in column G
Please help me start this what if analysis formula
I am not even sure where to begin
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