Trying to create a formula

Closed
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
Hello,

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

Thanks

2 replies

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...
"=g41*.20"

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.

0
TrowaD Posts 2900 Registration date Sunday September 12, 2010 Status Moderator Last seen September 12, 2022 523
Jun 13, 2013 at 11:15 AM
Hello

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:
=G7+0.2*I7
Drag this formula down to fill out the column.

Best regards,
Trowa
0
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!
0