Trying to create a formula

resiresale Posts 1 Registration date Thursday June 13, 2013 Status Member Last seen June 13, 2013 - Jun 13, 2013 at 09:56 AM
 Blocked Profile - Jun 13, 2013 at 11:19 AM

what I am trying to do is that I have a $ amount in g7;g41 + 20% of the dollar amount in i7;i41 to give total payout in k7;k41


2 responses

Blocked Profile
Jun 13, 2013 at 10:09 AM
Good Morning.

I hope this helps....
formulas in excel start with an '=' sign. So if you wanted 20% of a cell it would be...

You can also use SUM(); like so...
=sum(i7:k7) would add i7 and k7 together.

I hope this helps in getting your question answered.

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Jun 13, 2013 at 11:15 AM

To prevent confusion:
=sum(i7:k7) would add i7, j7 and k7
=sum(i7,k7) would add i7 and k7

Resiresale, I think you are looking for the following formula in K7:
Drag this formula down to fill out the column.

Best regards,
Blocked Profile
Jun 13, 2013 at 11:19 AM
Thank you for the clarifiction, I don't know why I thought K came after I, poor J!