Forum Discussion
Can't figure out two simple formulas... please help!
I am reasonably new to complicated Excel spreadsheets and am writing a P&L at the moment for a new company. I have costs that vary at different brackets, 40,100 and 200 customers. I want the ...
Easiest to demonstrate with a working example (attached). Re your first question, create a table with your brackets and create a simple LOOKUP.
The answer to your second question is:
=$C$23*(N23/$H$23)the dollar signs fix the column and row numbers. Copy this one down and N23 will become N24, N25 etc.. Copy it across and N23 will become O23, P23 etc. Don't want that, put a dollar in front of the N only.
