| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create a dollar value
Cell B1 is a time formated cell. B2 is formated to dollars. I would
like to creat a formula in cell B3 that multiplies B1 x B2 and returns a dollar value. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a dollar value
If b2 is a rate per hour and b1 reflects the number of hours formatted as time
=B1*24*B2 -- Regards, Tom Ogilvy "Good Time" wrote: Cell B1 is a time formated cell. B2 is formated to dollars. I would like to creat a formula in cell B3 that multiplies B1 x B2 and returns a dollar value. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a dollar value
Also, after entering the formula, format B3 as General or Dollars.
-- Regards, Tom Ogilvy "Good Time" wrote: Cell B1 is a time formated cell. B2 is formated to dollars. I would like to creat a formula in cell B3 that multiplies B1 x B2 and returns a dollar value. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Create a dollar value -- Thank you
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding dollar amounts in half dollar increments | Excel Worksheet Functions | |||
| dollar mark | New Users to Excel | |||
| Comparing Row by Row - A-D dollar amounts to E dollar amount | Excel Worksheet Functions | |||
| dollar amounts | New Users to Excel | |||
| Dollar signs | New Users to Excel | |||
Linear Mode
