This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I have the following formula in Cell L18:
=IF(HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18<$AG$17,$AG$17,IF(HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18>$AL$17,$AL$17,HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18))
Right now, if I leave K18 blank, the value of AG$17 will display. I have tried using the following formula, but I get an answer of FALSE
=IF(K18>0,IF(HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18<$AG$17,$AG$17,IF(HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18>$AL$17,$AL$17,HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18))
How can I modify the formula so that L18 will be blank if K18 is blank?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
=IF(K18="","",IF(HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18<$AG$17,$AG$17,IF(HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18>$AL$17,$AL$17,HLOOKUP($K18,$AH$16:$AL$17,2,1)*$K18)))
gsnu201005
PERFECT!! Thank you SO MUCH!