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