Trying to change from text to number with a formula calculation

%3CLINGO-SUB%20id%3D%22lingo-sub-2740172%22%20slang%3D%22en-US%22%3ETrying%20to%20change%20from%20text%20to%20number%20with%20a%20formula%20calculation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2740172%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20creating%20a%20spreadsheet%20for%20some%20cattle%20-%20if%20they%20weight%20700%20pounds%20or%20more%20they%20will%20be%20worth%20%241600%20and%20if%20they%20are%20less%20than%20700%20they%20will%20be%20%241500...i%20have%20the%20formula%20working%20fine%2C%20however%2C%20the%20results%20of%20the%20formula%20won't%20let%20me%20calculate%20a%20total%20sum%20at%20the%20bottom%20as%20it%20won't%20recognize%20the%20results%20of%20the%20formula%20as%20numbers%20and%20I%20can't%20get%20it%20to%20-%20this%20would%20be%20only%20for%20the%20blue%20rows%20(not%20pink)%20but%20i%20want%20the%20pink%20and%20blue%20rows%20to%20total%20at%20the%20bottom%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22wannabvet75_0-1631284883434.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F309617i3A3701FAE6A65352%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22wannabvet75_0-1631284883434.png%22%20alt%3D%22wannabvet75_0-1631284883434.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2740172%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

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, the results of the formula won't let me calculate a total sum at the bottom as it won't recognize the results of the formula as numbers and I can't get it to - this would be only for the blue rows (not pink) but i want the pink and blue rows to total at the bottom

 

wannabvet75_0-1631284883434.png

 

2 Replies

@wannabvet75 

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!