Forum Discussion
Trying to get all formulas into one cell
GOAL - Trying to get all formulas into 1 cell – B8 SEE BELOW TABLES -If B13 is greater than B6 then B8 s/b 100% -B8 should also have percentage from B7 divided by B5 -Already calculated in ...
As variant
=MAX( B13>B6, ( B5-MAX(0, B6-B13) )/B5)However, not sure I understood the logic correctly. Here
it shall be 57, isn't it?