Aug 19 2022 01:03 PM
Hi there, I hope someone can help me out with this as I'm fairly new to Excel. Ill try to explain as best I can considering I'm doing this from a mobile device;
I am trying to figure out the formula(s) that does the following:
I have spent hours trying to figure out how to use the IF(OR( commands with no luck. I wonder if anyone can help me with this formula for this please. Remember there are 20 different calculations that would need to happen depending on what the selection is. I'm pretty sure it would be a similar formula for both, the name lookup and the calculation.
Thanks in advance.
Aug 19 2022 01:12 PM
SolutionSee the simplified demo workbook attached to this reply.
Aug 19 2022 01:50 PM
Aug 19 2022 01:12 PM
Solution