Not sure how to enter this formula: If Cell B3 says "P", then Cell B17 is multiplied by .9. If B3 says "Q", then Cell B17 is multiplied by .75, and if B3 is blank, B17 stays the same. Thanks in advance!
Not sure if by blank you meant nothing or a space. My formula handles the nothing. If you want the space, then change to: b3=" "
Better people on this board should come up with a better way to handle the blank.