lundi 16 avril 2018

Excel nesting - IF / AND Query part two?

Hi I Had a query earlier and thought I had cracked it with the help of Richard but it doesn't appear so Excel - nesting the IF and AND function enter image description here

I have attached an image and what I am trying to achieve to make my query clearer if anyone can help??

* If E is correct then cell F will be set to match D manually               
* If E is yes and F is set to 111 then G will populate with the contents of C               
* If E is no and F is set to anything but 111 then it will return 0                 


* If E is correct then cell F will be set to match D manually               
* If E is yes and F is set to 112 then H will populate with the contents of C               
* If E is no and F is set to anything but 112 then it will return 0                 


* If E is correct then cell F will be set to match D manually               
* If E is yes and F is set to 118 then I will populate with the contents of C               
* If E is no and F is set to anything but 118 then it will return 0                 


* If E is correct then cell F will be set to match D manually               
* If E is yes and F is set to 119 then J will populate with the contents of C               
* If E is no and F is set to anything but 119 then it will return 0     

PLEASE HELP I HAVE BEEN ON WITH THIS ALL DAY !!!

Thanks in advance !!!

Aucun commentaire:

Enregistrer un commentaire