Adding whole dollar amounts, then a percentage, then a partial dollar amount?

**pede69** · 09-14-2011, 04:46 PM

Would someone mind giving me the correct format for the following expression?

sum=f+g+2.9%+.35

Where f an g are columns which have dollar values in them, plus 2.9%, plus 35 cents.

Thank you for your help,
John

Version 2003

**TMS** · 09-14-2011, 05:58 PM

Assume row 2:

sum=f+g+2.9%+.35

=(F2+G2)*1.029+0.35

Regards

**pede69** · 09-14-2011, 06:09 PM

Thanks a lot.

Is there not a way to apply these values to the entire columns within one cell .

Thanks,
J

**TMS** · 09-14-2011, 06:15 PM

Is there not a way to apply these values to the entire columns within one cell

OK, I understand all the words ... I just don't follow when they're joined up like this ;-)

What do you mean? You can just copy the formula down the column using autofill.

Regards

**pede69** · 09-14-2011, 06:23 PM

Thank you and I am sorry for the confusion.

I have just never used autofill.

I'll take it from here.

Thanks again,
John

Adding whole dollar amounts, then a percentage, then a partial dollar amount?

LinkBack

Thread Tools

Rate This Thread

Display

Adding whole dollar amounts, then a percentage, then a partial dollar amount?

Re: Adding whole dollar amounts, then a percentage, then a partial dollar amount?

Re: Adding whole dollar amounts, then a percentage, then a partial dollar amount?

Re: Adding whole dollar amounts, then a percentage, then a partial dollar amount?

Re: Adding whole dollar amounts, then a percentage, then a partial dollar amount?

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions