View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
h. h. is offline
external usenet poster
 
Posts: 4
Default add a cell reference to the start of a formula

my cell is custom formatted to read, "## "min. =" $##.##"
my formula is =FIXED(D30/60,3)*F28
the cell reads min. = $19.49

what i'm missing is the number of minutes, which is displayed in cell F28.
so i just need to reference that cell at the start of my formula. the
question is how?!

thanks for any help.