Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Using..
=IF(O5N5,"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 |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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. "Bob Barnes" wrote: Using.. =IF(O5N5,"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 |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
hi
using 2003 here. click into the cell with the formula. on the menu bar.... click insertsymble scroll down and select the delta symble. click insertok 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" wrote: Using.. =IF(O5N5,"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 |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you - Bob
"FSt1" wrote: hi using 2003 here. click into the cell with the formula. on the menu bar.... click insertsymble scroll down and select the delta symble. click insertok 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" wrote: Using.. =IF(O5N5,"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 |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thank you - Bob
"dlw" wrote: 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. "Bob Barnes" wrote: Using.. =IF(O5N5,"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 |
#6
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
you're welcome
regards FSt1 "Bob Barnes" wrote: Thank you - Bob "FSt1" wrote: hi using 2003 here. click into the cell with the formula. on the menu bar.... click insertsymble scroll down and select the delta symble. click insertok 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" wrote: Using.. =IF(O5N5,"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
HELP on "left","right","find","len","substitute" functions | Excel Discussion (Misc queries) | |||
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next | New Users to Excel | |||
Complex if test program possible? If "value" "value", paste "value" in another cell? | Excel Discussion (Misc queries) | |||
Insert "-" in text "1234567890" to have a output like this"123-456-7890" | Excel Discussion (Misc queries) |