Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I know there must be a way to have the results of an If-Then formula be
functioning rather than text. The following statement gets the $100 or $0 results that I want =IF((P5+I5)38,"$100","$0") However, the $100 or $0 is not a functioning number that can be added, subtracted or multiplied. Excel is handling it as text. Thank you very much for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to Convert Figures into Text in Excel | Excel Worksheet Functions | |||
Displays the number in text. (One thousand two hundred thirty four | Excel Worksheet Functions | |||
Number format | Excel Discussion (Misc queries) | |||
spell number | Excel Worksheet Functions | |||
excel | Excel Worksheet Functions |