how do i enter an absolute formula?

  • Thread starter Thread starter danielledever
  • Start date Start date
D

danielledever

I have a certain problem with an absolute formula. I know how to us
the dollar signs in front of the row and column, I don't know how t
set up the formula for the specific question.

6. In I 4, create a formula to determine what percentage of the tota
World Tour is the Airfare. Remember, you need an absolute formula.
Copy the formula down to I9. Format as %
I am not sure what cells to use. If you can help me I will send mor
info.

thanks
danielle
:confused
 
Hi Danielle
not much data provided nut if your values are in column H (from H4 to
H9) and the total is in H10 try in I4
=H4/$H$10
format as percentage and copy down
 
Back
Top