Rookie_of_the_year
New Member
- Joined
- Mar 5, 2019
- Messages
- 3
Hello Everyone,
Could someone let me know if there is a way to add the results of a calculation into the comment for a selected range? if so, could the results in the comment change if any of the values change?
GM% FormulaCustomer A Price - Cost) / (Customer A Price)
<tbody>
</tbody>
The desired outcome would be to have a comment for each customer price (i.e. GM% 43.07%).
Please let me know if additional information is required.
Thanks again for taking the time to review my post!
Could someone let me know if there is a way to add the results of a calculation into the comment for a selected range? if so, could the results in the comment change if any of the values change?
GM% FormulaCustomer A Price - Cost) / (Customer A Price)
Cost | Customer A Price | Customer B Price | Customer C Price | GM% Customer A | GM% Customer B | GM% Customer C | |||
101.24 | 216.35 | 195.00 | 200.00 |
<colgroup><col width="115"><col width="114" span="2"></colgroup><tbody> </tbody> | 48.08% | 49.38% | |||
112.10 | 190.25 | 171.00 | 176.00 |
<colgroup><col width="115"></colgroup><tbody> </tbody> |
<colgroup><col width="114"></colgroup><tbody> </tbody> | 36.31% | |||
112.41 | 197.45 | 177.00 | 182.00 |
<colgroup><col width="115"></colgroup><tbody> </tbody> |
<colgroup><col width="114"></colgroup><tbody> </tbody> | 38.24% | |||
<colgroup><col width="78"></colgroup><tbody> </tbody> |
<tbody>
</tbody>
The desired outcome would be to have a comment for each customer price (i.e. GM% 43.07%).
Please let me know if additional information is required.
Thanks again for taking the time to review my post!