Forum Discussion
Solved
Trying to change from text to number with a formula calculation
I am creating a spreadsheet for some cattle - if they weight 700 pounds or more they will be worth $1600 and if they are less than 700 they will be $1500...i have the formula working fine, however, t...
Don't use quotes around the values, and don't include the $ sign in the formula:
=IF(M5>=700,1600,1500)
Format the cell with the formula as currency - this will add $ in the displayed value.
Don't use quotes around the values, and don't include the $ sign in the formula:
=IF(M5>=700,1600,1500)
Format the cell with the formula as currency - this will add $ in the displayed value.
Oh my goodness! You are amazing! Thanks so much for the help! I've spent an hour trying to fix this and with your help I had it fixed in 2 minutes!