Excel formula

%3CLINGO-SUB%20id%3D%22lingo-sub-1855963%22%20slang%3D%22en-US%22%3EExcel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1855963%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Superstars%2C%20please%20help%2C%20I%20just%20cannot%20wrap%20my%20head%20around%20this%20function%20I'm%20trying%20to%20do.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20spreadsheet%20of%20my%20daughter's%20medication%2C%20I%20have%20counted%20out%20the%20number%20of%20pills%20she%20has%20%22in%20stock%22%2C%20how%20much%20she%20needs%20to%20take%20on%20a%20daily%20basis%20and%20how%20many%20days%20stock%20she%20has.%20I%20would%20like%20excel%20to%20automatically%20calculate%20how%20the%20amounts%20remaining%20once%20we%20plug%20in%20a%20yes%2Fno%20in%20a%20cell.%20Sheet%20attached%20for%20you%20to%20see%20what%20I%20am%20talking%20about%20(I%20am%20shocking%20at%20communication)%3C%2FP%3E%3CP%3EThank%20you%3C%2FP%3E%3CP%3EDorothy%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1855963%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1856037%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20formula%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1856037%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F858315%22%20target%3D%22_blank%22%3E%40doranbe%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIn%20the%20attached%20version%2C%20I%20have%20inserted%20two%20columns%20for%20the%20remaining%20quantity%20and%20days.%20Both%20use%20the%20COUNTIF%20function%20to%20subtract%20from%20the%20initial%20values.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi Superstars, please help, I just cannot wrap my head around this function I'm trying to do.

 

I have a spreadsheet of my daughter's medication, I have counted out the number of pills she has "in stock", how much she needs to take on a daily basis and how many days stock she has. I would like excel to automatically calculate how the amounts remaining once we plug in a yes/no in a cell. Sheet attached for you to see what I am talking about (I am shocking at communication)

Thank you

Dorothy

 

1 Reply
Highlighted

@doranbe 

In the attached version, I have inserted two columns for the remaining quantity and days. Both use the COUNTIF function to subtract from the initial values.