Home |
Search |
Today's Posts |
#2
![]() |
|||
|
|||
![]()
Spoony_13wrote...
I am using an IF function and I want my TRUE value to say "YOU OWE X" with the "X" being the numerical value cell F50. The way I am setting it up, it keeps reading "YOU OWE F50." How can I get the cell to read the number in F50 instead of just F50? Hi, Try, ="You owe " & TEXT(F50,"$0.00") That is one way. Best regards, Kevin |