True number as the result to an If-Then function

K

kingham78

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!
 
F

FloMM2

Try this:
=IF(P5+15)>38,100,0)
make sure you format the cell that this formula is going into as currency
with 2 decimal points.
You should be off and running.
 
S

SteveW

Changing your name doesn't hide the fact that this is the FOURTH identical
POST

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

True number as the result to an If-Then function 0
Excel TVM functions of RATE, NPER, PMT, PV, and FV fail to produceresults that are known about Geome 0
Numaric to Inword in excel by VB 1
IF functions - more than one condition 3
User form - Testing for numbers or text 5
Multiple Conditions in a Formula 2
Nest no more than seven functions??? 5
Making a cell empty 3

Top