Multiple Functions - Help

[mystic19]

Hi, I have an idea of what I want to do but not sure how to execute it or if it is possible since it involves multiple roles.

In column "E" for "Additional?" :

• When '0 is inserted, I want it to automatically populate "N/A" into column "F" ("Expiry Date").
• When '+1 is inserted, I want it to leave column "F" blank, however, I want it to do a SUM of column "C" (Volume Available) and "B" (Stock Volume) in its respective cell in column "G" (Total Volume Available).
• Similarly, if '+2 is inserted it should do the same as the above but just double the Stock Volume value in the final SUM equation.

Any help with this will be greatly appreciated, Thanks!

 

[shift-del]

That would be this.

Mappe18
	B	C	D	E	F	G
3	Stock volume	Volume available		Additional	Expiry date	Total volume available
4	5	8		0	#NV
5	12	44		+1		56
6	7	34		+2		82
Tabelle1

Cell Formulas
Range	Formula
F4:F6	F4	=IF(--E4=0,NA(),"")
G4:G6	G4	=IF(--E4=0,"",E4*(B4+C4))