Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to do a basic formula for Xcel?
I would be ever so greatful if someone could tell me how to function a colum
to covert - ex: if I type 501 in A13 , I would like the amount of $36.00 to automatically show up in colum D13 - and then if colum B is quanities, than if I type in 4 in colum B , colum E to show $144.00 , hence the $36.00 per job and I typed 4 as the quanities.. At least the first part and I will be able to figure out the rest. Pleasssse, it would make it soo much easier! A million Thnx to whoever replies!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to do a basic formula for Xcel?
Hi!
Enter this formula in D13: =(A13=501)*36 Format the cell as CURRENCY Enter this formula in E13: =D13*B13 Format the cell as CURRENCY Biff "NIKKI" wrote in message ... I would be ever so greatful if someone could tell me how to function a colum to covert - ex: if I type 501 in A13 , I would like the amount of $36.00 to automatically show up in colum D13 - and then if colum B is quanities, than if I type in 4 in colum B , colum E to show $144.00 , hence the $36.00 per job and I typed 4 as the quanities.. At least the first part and I will be able to figure out the rest. Pleasssse, it would make it soo much easier! A million Thnx to whoever replies!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Basic if formula | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Help - basic formula question | Excel Worksheet Functions | |||
Dragging a Formula & Basic Setting Changes | Excel Discussion (Misc queries) | |||
Formula in Visual Basic For Excel | Excel Discussion (Misc queries) |