If <$ then %, if >$$ then higher % formula?

[LKM Kevin]

Hi,

I have a done a little searching and could not figure this one out.

I have a total cell that needs to have a payment breakdown figured below it.

If C18 is the cell total and rows 20:25 show the payment breakdown, this is what I am trying to get to work in formula:

IF C18 <$5000 display 50% in C21 and 50% in the C22, and do not show anything in row 23 ("").
IF C18 $5001-$30000 display 20% in C21, 30% in C22, 50% in C23
IF C18 >$30001+ display 20% in C21, 30% in C22, 30% in C23, 20% in C24

Also, I would like to have the words Deposit, Start, Mid Pay, Finish, show up in respect to the percentages that are to be paid and hide the ones not being used. If it was <$5000 then only deposit and finish would be displayed, $5k-$30k would show Deposit, Start, Finish, etc.

How do I have the multiple ranges with if then statements to change based on what the initial value is?

Thanks!