Formula IF + validation

[kahlran]

Hi!

Fairly new to advanced excel, but I'm creating a small storagemanaging-database, and to get a table which shows quantity of a specific items, I need to validate a cell to continue an operation.

I want a cell to change to -1 (storage quantity), if 'Delivered' changes to 1 to a specific cell, IF another cell contains a certaint string of 'TEXT'.

Example: If 'Item' is "Winterjacket Size L", and 'Delivered' changes to 1, on 'Worksheet Storage'; change 'Quanity' to -1 "Winterjacket Size L" on worksheet 'Storage Quantity.

I'm not sure if I described it just right. Hope someone understand what I want :D


kind regards

[:) Sixthsense :)]

It will be easier to understand your requirement as an attachment file with expected output because you have not mentioned any cell references in your description

[kahlran]

Artikkeldata.jpgSkjema.jpg

Appreciated!

[kahlran]

Skjema.jpg is where I want to control everything, artikkeldata is where data (such as quantity) is stored.

[:) Sixthsense :)]

Sorry I am unable to suggest since I cannot work with picture and your screenshot doesn't have any row/column references.

[kahlran]

Worksheet.jpg

Sorry, didn't cross my mind :p

Hope you can help

[kahlran]

Managed to do it by forula: =SUM((Skjema!$F$4:$F$40="Kjeledress Vinter M")*(Skjema!$G$4:$G$40))

Then taking that value minus the stored value.