Forum Discussion

Copper Contributor

Mar 11, 2020

Beginner at Formulas... need help

I need to take the total from column Adlts (column E) and multiply that number by 25, putting the sum in column Ex25 (Column F). Column E are the number of adults that have to pay for a dinner (Colum...

excel

Formulas and Functions

mathetes

Silver Contributor

Mar 11, 2020

TPhipps

If all you're looking for is the formula to multiply 3 by 25, assuming the first number is in Column E and Row 2 of your spreadsheet, and your formula is going into cell F2, the formula would be

=E2*25

But if you're actually looking for the adults to share the cost of students (a guess at what "Stu" represents) and whatever "Prec" stands for....then I'd ask you to spell this whole situation out a bit more. And, ideally, please upload the actual spreadsheet you're developing along with that more thorough explanation.

johne1650
Copper Contributor
Mar 12, 2020
mathetes
John. I have done something stupid.
Now when I type in =B45-C12, instead of getting a number, I get =B45-C12. What have I done?
- Savia
  Iron Contributor
  Mar 12, 2020
  johne1650 You have probably formatted that cell as Text, which overrides your ability to write formulas. Change it to General or another format and then re-enter the formula. If that still doesn't work, try Find & Replace = with = to kick Excel into noticing the change.