Multiply 2 cells then add a %

**jcblinger** · 06-23-2008, 06:05 PM

Hi I'm trying to multiply two cells which I have no problem with. But then I want to add a % I have in another cell.

example 1366 hrs x 46 rate + 17% = 73518.12

THANKS

**oldchippy** · 06-23-2008, 06:07 PM

Hi,

Try this

=(A1*B1)*1.17

**jcblinger** · 06-23-2008, 06:11 PM

I need the 1.14 to be a cell value ex. C1

**oldchippy** · 06-23-2008, 06:16 PM

Try

=A1*B1+((A1*B1)*C1) where C1 is your 17% or 14%

**jcblinger** · 06-23-2008, 06:20 PM

Yes, thank you that worked perfectly!

Multiply 2 cells then add a %

LinkBack

Thread Tools

Rate This Thread

Display

Multiply 2 cells then add a %

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions