"Delta"

[Bob Barnes]

Using..
=IF(O5>N5,"O",IF(O5<(N5-0.05),"X","D"))

Which font can be used to see "Delta" for "D" above, and how is that entered
in the IF statement?

TIA - Bob

 

[dlw]

I just go into Word, go Insert Symbol, all kinds of neat ones come up,
inclucing delta, insert it into the document, then copy and paste it into
your sheet.

 

[FSt1]

hi
using 2003 here.
click into the cell with the formula.
on the menu bar.... click insert>symble
scroll down and select the delta symble. click insert>ok
the delta will appear as the end of the formula.
click into the formula just before the "D". delete all characters upto the
delta.
arrow past the delta. replace the double quotes and 2 close parenthesis.
done.

regards
FSt1

 

[Bob Barnes]

Thank you - Bob

hi
using 2003 here.
click into the cell with the formula.
on the menu bar.... click insert>symble
scroll down and select the delta symble. click insert>ok
the delta will appear as the end of the formula.
click into the formula just before the "D". delete all characters upto the
delta.
arrow past the delta. replace the double quotes and 2 close parenthesis.
done.

regards
FSt1

 

[Bob Barnes]

Thank you - Bob

I just go into Word, go Insert Symbol, all kinds of neat ones come up,
inclucing delta, insert it into the document, then copy and paste it into
your sheet.

 

[FSt1]

you're welcome
regards
FSt1

Thank you - Bob