Forum Discussion
Need help with a simple formula
Need help with what would be a simple formula for cell B11, B12, and B13.
Cell B11 should be $150 (via the formula)
Cell B12 should be $500 (via the formula)
Cell B13 should be $15 (via the formula)
Can someone help me figure out the formula for this? (note, there will be more than just 6 rows of data, this is just an example....
Thank you!!
A single formula that generates the entire range (Microsoft 365 only):
or with a more traditional formula:
Adjust the ranges as needed.
