If or Macro or something else or not possible???

[CFP]

Well, I tried posting this in the functions section and no one replied so I'll try here.

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!!!

[Steel Monkey]

Hi there

Formulas arent my strong point, but give the below a try :

Please Login or Register  to view this content.

That should work, however if you want a macro to do it have a look at the below :

Please Login or Register  to view this content.

Let me know how it goes!

[Leith Ross]

Hello CFP,

Here is the formula. Change D1 to whichever cell you want.

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[CFP]

You are BOTH right based on the information I gave you. Unfortunately my logic was wrong, no surprise there.

I have altered what you gave me to work except for one situation. ( I think)

I have this

=IF(B24<0,ROUNDUP(B24/1000,0)*-1000)

The problem is when I have a positive number it returns False instead of zero.

Do you know how to correct this problem?

Thanks so much, you are both awsome!!!

[Leith Ross]

Hello CFP,

Can you explain what results you want with this formula? Please give examples.

Sincerely,
Leith Ross

[jasoncw]

I have this

=IF(B24<0,ROUNDUP(B24/1000,0)*-1000)

The problem is when I have a positive number it returns False instead of zero.

Do you know how to correct this problem?

Not sure where you are going with this, but this should correct your problem:

=IF(B24<0,ROUNDUP(B24/1000,0)*-1000,0)

HTH

Jason

[CFP]

Not sure where you are going with this, but this should correct your problem:

=IF(B24<0,ROUNDUP(B24/1000,0)*-1000,0)

HTH

Jason

I just got it with this. It seems to work correctly. It's a formula to borrow in thousand dollar increments in certain situations.

=IF(B24>11000,ROUNDDOWN(B24-10000,0),0)

Thanks

[CFP]

Hello CFP,

Can you explain what results you want with this formula? Please give examples.

Sincerely,
Leith Ross

I got it but thanks.

It's a problem of borrowing in thousand dollar increments only, and if a balance falls under a certain level.

Now I've got that working but am working on the repayment formula in thousand dollar increments. I have it working except I do have a glitch.

=IF(B24>11000,ROUNDDOWN(B24-10000,0),0)

It is set up to repay a loan in thousand dollar increments only, and only if there is over $10000 in the account, which is working, however I don't know how to stop it from repaying if there is no loan - or not exceeding the loan amount.

Thanks.