A formula to calculate in Column M, Excel assignment help

User Generated

SYGhgbe528

Business Finance

Description

I need help with a formula to calculate in Column M.

This will be calculated by taking B3*H3 and then from that total each time I3 goes down by 1 it will subtract from that total the number that is in B3.


Unformatted Attachment Preview

Campaign Tracker Client $ Monday FRIEDLANDER 250 1 BUSCEMI Tuesday To Do Left Last Blast Times Dist. 5 4 5/18 1 250 4 4 5/18 2 PRESSER 250 PRO BONO 5/11 2 KATZ 250 14 14 4/29 3 KOZERA 150 26 26 5/10 1 BATRA 100 14 14 5/17 3 HEWETT 195 2 2 5/17 4 VERMEEREN 250 5 5 5/13 4 JAYNIE SMITH 195 2 2 5/20 2 HORVAT 250 12 12 5/19 1 IODICE 200 7 7 5/4 3 ROBERTSON 250 PRO BONO 5/2 2 ORESTIS 350N 250L BILLING 5/12 4 FLEMMING 250 7 7 5/16 1 WOODITCH 250 11 11 5/12 2 DUNN 160 4 4 5/20 1 AMEN 350 18 18 5/19 3 CORREIA 150 23 23 5/16 1 TRETTENERO 150 23 23 5/11 2 SLOVON 250 4 4 5/10 2 LEIBIG 160 5 1 5/23 1 MEYER 150 13 12 5/24 2 ZEUG 250 3 3 5/13 2 LOWERY 160 6 6 5/25 1 CONGER 160 1 5 4 5/23 1 W. SMITH 150 1 14 13 5/19 1 HOFFMANN 150 29 27 5/24 1 1 4 1 2 Wednesday Thursday Friday No Charges VSD 3 2 1 1
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Okay, so:I went through and converted all text-based numbers into text. This allows us to actually use formulas now :)The spreadsheet has been corrected to operate as you want it to.

Campaign Tracker
Client

$

Monday

FRIEDLANDER

250

1

BUSCEMI

Tuesday

To Do

Left

Last Blast

Times Dist...


Anonymous
I was having a hard time with this subject, and this was a great help.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags