ExcelBanter - whole numbers plus a percentage

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - whole numbers plus a percentage (https://www.excelbanter.com/excel-discussion-misc-queries/193789-whole-numbers-plus-percentage.html)

Marko

whole numbers plus a percentage

If c4 is $1,500 and I want to add c5 4.845% to get sum of them in c6.

FSt1

whole numbers plus a percentage

hi
in c6, enter.....
=C4+(C4*C5)
4.845% = .04845 formated as general.

regards
FSt1

"Marko" wrote:

If c4 is $1,500 and I want to add c5 4.845% to get sum of them in c6.

daddylonglegs

whole numbers plus a percentage

or

=C4*(1+C5)

"FSt1" wrote:

hi
in c6, enter.....
=C4+(C4*C5)
4.845% = .04845 formated as general.

regards
FSt1

"Marko" wrote:

If c4 is $1,500 and I want to add c5 4.845% to get sum of them in c6.

All times are GMT +1. The time now is 06:17 AM.