If I follow you well, and your data is in A2:B4 (row 1 is for headers) then netsales could be calculated as:
Formula:![]()
=SUMPRODUCT(A2:A4*(1/(1+B2:B4)))
If I follow you well, and your data is in A2:B4 (row 1 is for headers) then netsales could be calculated as:
Formula:![]()
=SUMPRODUCT(A2:A4*(1/(1+B2:B4)))
Best Regards,
Kaper
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks