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