Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Format a cell to make 1=$3.00 per cell then total?
How do I Format a cell to make 1=$3.00 per cell then total,
So if user puts 2 it will then equal $6.00. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Format a cell to make 1=$3.00 per cell then total?
Theun, how about in another cell, put you number in A1 and this in another
cell =A1*3 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Theun4gvn" wrote in message ... How do I Format a cell to make 1=$3.00 per cell then total, So if user puts 2 it will then equal $6.00. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Format a cell to make 1=$3.00 per cell then total?
or just multiply the SUM formula by 3 and format as currency.
-- HTH RP (remove nothere from the email address if mailing direct) "Paul B" wrote in message ... Theun, how about in another cell, put you number in A1 and this in another cell =A1*3 -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Theun4gvn" wrote in message ... How do I Format a cell to make 1=$3.00 per cell then total, So if user puts 2 it will then equal $6.00. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I Format a cell to make 1=$3.00 per cell then total?
right click sheet tabview codecopy/paste thisSAVE.works row2 or below in
col A Private Sub Worksheet_Change(ByVal Target As Range) If Target.Row < 2 Or Target.Column < 1 Then Exit Sub Application.EnableEvents = False If IsNumeric(Target) Then Target = Target * 3 Application.EnableEvents = True End Sub -- Don Guillett SalesAid Software "Theun4gvn" wrote in message ... How do I Format a cell to make 1=$3.00 per cell then total, So if user puts 2 it will then equal $6.00. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I make a format to follow the cell | Excel Discussion (Misc queries) | |||
How can I make a running total change in a new cell | Excel Worksheet Functions | |||
make cell show blank when total is zero | Excel Discussion (Misc queries) | |||
format cell to show leading zeros and make cell a three digit fiel | Excel Worksheet Functions | |||
make cell show blank when total is zero | Excel Discussion (Misc queries) |