pictures in formulas

T

T.J.S.

Is there anyway to create an =if() formula that can
display a picture for its' True statement and nothing for
its' False?
 
E

Earl Kiosterud

T.J.S.,

No. An IF function lives in a formula, which lives in a cell, and can only
return a value (text, number, boolean, etc) to the cell. A formula cannot
"do" anything (like expose a picture) -- a macro can.

If your heart is set on this approach, you could possibly make a font of the
picture, then it would really be text, and the IF could return a character
in that typeface (font) (your picture). You'll need a font-making program.

Or you can write a macro that checks what the IF would examine, and plops a
pic into the sheet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top