Apr 09 2022 05:34 PM
Hello,
Can someone help me to update a discount value for the below table and please share the formula for the revenue also.
Thank you,
Kiran
Apr 10 2022 01:56 AM
SolutionPlease share a screenshot that shows the row numbers and column letters. Even better, share a sample workbook through OneDrive, Google Drive or similar.
Apr 10 2022 12:53 PM
Thanks for sending the sample workbook. In E18:
=INDEX($H$5:$K$7,MATCH(C18,$G$5:$G$7),MATCH(B18,$H$4:$K$4,0))*D18
Revenue will be calculated automatically with the formula you already have.
Apr 10 2022 01:56 AM
SolutionPlease share a screenshot that shows the row numbers and column letters. Even better, share a sample workbook through OneDrive, Google Drive or similar.