Microsoft Excel Question?


In cell G4, enter the formula to compute the total cost of Catelyn's trip with insurance, referring to the Insurance Rate in B11 as an absolute cell reference. Apply the Insurance to the Total Number with Taxes. I have written this out a thousand different ways and am being told each time that my answer is incorrect. Does anyone know how the formula would be written? Thanks.

Written by Phelps in Software


Better Answer

=F4 + ( F4*$B$11)

I just did this and it is correct in Wileyplus

Written by Dwayned4


Other Answers

Use the PMT function.

Written by Anonyms

You have not provided much info as to how your sheet is laid out But - Try something like Insert in Cell G4 =(cell with total number)+(cell with taxes)*/+$B$11 The $ sign indicates absolute addressing/reference for cel B11 HTH

Written by Denn

=F4 + ( F4*$B$11)

I just did this and it is correct in Wileyplus

Written by Dwayned4