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
Blocked Profile - Jun 13, 2013 at 11:19 AM
Related:
- Trying to create a formula
- Create skype account with gmail - Guide
- Create snapchat account - Guide
- Number to words in excel formula - Guide
- Logitech formula vibration feedback wheel driver - Download - Drivers
- Excel grade formula - Guide
2 responses
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.
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.
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
December 27, 2022
555
Jun 13, 2013 at 11:15 AM
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
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
