I am trying to find a function where if I have PERSON X in a cell I want to multiply a number from a different cell by designated number, but if it is PERSON Y then I want to multiply by a different number. I have this so far and it works for ONE person. How do I add another user?
=PRODUCT(IF(D2="PERSON X",W2*85,""))
Any feedback would be greatly appreciated. Thanks.
Bookmarks