Multiplication formula...is this conditional formatting?

[mighty mouse]

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!

 

[mortgageman]

=IF(b3="",1,LOOKUP(b3,{"P","Q"},{0.9,0.75}))*b17

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.

Gene, "The Mortgage Man", Klein

 

[Peter_SSs]

mighty mouse

You could see if this does what you want
=B17*LOOKUP(B3,{0,"P","Q"},{1,0.9,0.75})

 

[mortgageman]

Peter - yours will certainly work if B3 is empty. I'm just not sure if that is
what the OP meant by "blank". Since the OP has not yet answered, lets go with yours since it looks better! (no ifs)

Gene, "The Mortgage Man", Klein