K
kingham
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!
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!