Sep 10 2021 07:42 AM
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
Sep 10 2021 07:51 AM
SolutionDon'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.
Sep 10 2021 07:59 AM
Sep 10 2021 07:51 AM
SolutionDon'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.