Hello all! I'm perplexed, frustrated, and disturbed I can't figure this one
out. I need to come up with a multilayer "if" statement function that covers
the following information for translation and recording fees


A B C D
E
Language Trans Min Rec Min Trans per Word Rec Charges
per Word
# of words: 871
Afrikaans $85.00 $45.00 $226.46 HELP
Arabic $105.00 $55.00 $261.30 HELP
Austrian German $75.00 $40.00 $209.04 HELP

o.k... if the # of words is <999, then the rec charges per word is C
if the # of words is 1000<1999, then the rec charges per word is 2xC
if the # of words is 2000<2999, then the rec charges per word is 2.5xC
if the # of words is 3000<3999, then the rec charges per word is 3xC

So, for Afrikaans. if the number of words is 1342. then column E should
populate as $90.00.

I greatly appreciate any and all help!