Display value based on text, no value if blank

Hi,

I an trying to change the value in cell B4 based on the text I select from my drop down in A4. I have a formula that is doing this, but I can't figure out how to stop the formula if A4 is blank.

Thank you,

You can change the formula in B4 to this:

=IF(A4="","",IF(A4="Working",$B$1*$A$1,$B$1))

Hope this helps.

Pete

Thank you Pete, worked perfectly. Many thanks.

You're welcome, and thanks for the rep.

If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

Pete