Forum Discussion

TPhipps's avatar
TPhipps
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 (Column C and D are excluded from payment) and each dinner is $25.00.   

 

St LnameSt FnameStuPrecAdltsEx25
SampleJane123$75.00
excel
Formulas and Functions

4 Replies

  • mathetes's avatar
    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's avatar
      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's avatar
        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.

Resources