mercredi 25 février 2015

IF (Condition) and (another condition) increment cell

I have 2 spread sheets represent in CSV below:


1)


Type,Quantity


Games,1


Games,1


Games,2


DVD,1


2)


Type, Increment DVD, Games,


I want a nested if statement that IF type is "Games" and Quantity is 1, ++1 in the increment cell.


Any help will be much appreciated!


Aucun commentaire:

Enregistrer un commentaire