Trying to create a formula

Closed
Report
Posts
1
Registration date
Thursday June 13, 2013
Status
Member
Last seen
June 13, 2013
-
 Blocked Profile -
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


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
Posts
2847
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 13, 2022
491
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
Thank you for the clarifiction, I don't know why I thought K came after I, poor J!
0