Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
I need to create a workbook that will import a text file every month. Once
imported I need to do a formula. Let me see if I can explain.Col a has my numbers, I need to take the first 400 from A, and put the remainder in col C, but only if col a is 400 and if it is less that 400 take the contents on A and put in B. This is billing at different rates. A B C 2000 400 1600 400 400 0 395 395 0 1000 400 600 -------------------------------- 3795 1595 2200 Total of A should equal B+C Where do I need to start? I know very very little about macros and formula programming in Excel. TIA Gerald -- Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
In B1 enter ==IF(A1="","",MIN(A1,400,A1)
In C1 enter =IF(OR(A1="",B1=""),"",A1-B1) Drag/copy down. Gord Dibben MS Excel MVP On Wed, 06 Sep 2006 22:58:04 GMT, "gjameson via OfficeKB.com" <u21717@uwe wrote: I need to create a workbook that will import a text file every month. Once imported I need to do a formula. Let me see if I can explain.Col a has my numbers, I need to take the first 400 from A, and put the remainder in col C, but only if col a is 400 and if it is less that 400 take the contents on A and put in B. This is billing at different rates. A B C 2000 400 1600 400 400 0 395 395 0 1000 400 600 -------------------------------- 3795 1595 2200 Total of A should equal B+C Where do I need to start? I know very very little about macros and formula programming in Excel. TIA Gerald |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros
Thank you so much. This was perfect.
Gerald Gord Dibben wrote: In B1 enter ==IF(A1="","",MIN(A1,400,A1) In C1 enter =IF(OR(A1="",B1=""),"",A1-B1) Drag/copy down. Gord Dibben MS Excel MVP I need to create a workbook that will import a text file every month. Once imported I need to do a formula. Let me see if I can explain.Col a has my [quoted text clipped - 17 lines] TIA Gerald -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200609/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Strip workbook of macros, VBA, MS Query, etc. | Excel Discussion (Misc queries) | |||
Hide Macro's in Toolbar / Macro's list | Excel Discussion (Misc queries) | |||
how do I run excel 4.0 macros on excel 2000 | Excel Discussion (Misc queries) | |||
Enabling macros | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) |