I'm not very good at excel but need to make a nested if statement or macro I think. Here is what I'm trying to do.

Look at the value in a specific cell, say cell G6. If the value is >1000 and <10000 then I want to have a cell that has the G6 value rounded up. (meaning if is is 2344 I want the result cell to have the value 3000 in it or 5600 then I want 6000 in the result cell). If the value in G6 is >= 10,000 then I want the cell to simply have a 0 in it and if the G6 cell is <= 1000 then I want the result cell to say 1000.


THANKS!!!