ExcelBanter - True number as the result to an If-Then function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - True number as the result to an If-Then function (https://www.excelbanter.com/excel-discussion-misc-queries/113959-true-number-result-if-then-function.html)

kingham

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!

All times are GMT +1. The time now is 07:05 PM.