IF function

%3CLINGO-SUB%20id%3D%22lingo-sub-2143831%22%20slang%3D%22en-US%22%3EIF%20function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2143831%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20currently%20working%20on%20an%20excel%20forecast%20sheet%20that%20automatically%20replenishes%20inventory%20once%20it%20is%2C%20or%20goes%20below%20zero%20(safety%20stock%20not%20accounted%20for).%20I%20have%20tremendous%20difficulty%20with%20this%20school%20assignment%20so%20any%20help%20is%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2143831%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I am currently working on an excel forecast sheet that automatically replenishes inventory once it is, or goes below zero (safety stock not accounted for). I have tremendous difficulty with this school assignment so any help is greatly appreciated.

1 Reply

@_Daniel_Rupert_ 

 

Well, since it's a school assignment, I'm sure you don't actually want somebody to, you know, DO it for you. You don't give any indication of what you've even tried so it's a bit difficult to know what suggestions to make.

For starters, though, check out the IF and IFS functions. Here's a good website for your research.

https://exceljet.net/