Thread: True number as the result to an If-Then function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
kingham kingham is offline
external usenet poster
  
Posts: 2
Default True number as the result to an If-Then function
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 With QuoteReply With Quote