Greater Than

[Trebby]

Hi,

In Cell E8 I have the value "30"
In Cell F8 I have "Total Days"
In Cell G8 I have "=(IFERROR(IF(F8>20,"0",IF(F8<20,SUM(20-F8))),""))" So if less than 20 is continues to sum and if more than 20 it returns 0
In Cell H8 I have "=IF(G8>=0,10,IF(G8=0,SUM(E8-20)))" so if equal or more than "0" in cell G8 it returns 10 days, but if G8 is "0", it should sum E8 - 20 days.

I can get G8 to calculate fine and H8 is always returning "10".

Please can you advise?

 

[Trebby]

With conditional formatting? Did you fix the formula?

Not the formula - but with colors. When G8 is greater than 0 it highlights the cell yellow, and H8 is more than 10 it goes completely white. They then switch when G8 equals 0 and H8 is equal or less than 10. Pain but it does the trick.

Thanks for your help pal.

 

[Aladin Akyurek]

Looks like...

1) G8...

=20-MIN(20,F8)

2) H8...

=E8-MIN(10,G8)

 

[Trebby]

Looks like...

1) G8...

=20-MIN(20,F8)

2) H8...

=E8-MIN(10,G8)

Hi - Thanks for taking the time to reply. That too didn't work.

 

[gaz_chops]

Maybe explain a bit more, how do they not work?

 

[Trebby]

Maybe explain a bit more, how do they not work?

Sorry H8...

=E8-MIN(10,G8)

Again wouldn't count from 10 down after 20 was reached in other cell. I will let you know if I have a better method, calling it a day are possibley looking at this for far to long :P

 

[gaz_chops]

So give a sample of the data! The data in your 1st post is misleading as the answer is 10?

 

[Aladin Akyurek]

Hi - Thanks for taking the time to reply. That too didn't work.

Try to provide examples along with the actual results you want to see. Note also that "didn't work" does not provide much to go on.

 

[Trebby]

Sorry if my post was explained that great

https://www.mediafire.com/?anb05fihf145hw5

In column E it should remain "10" until column D reaches "0". Once that happens E should then count down from 10. Both examples are pretty close to what I want. Use column C to enter days.

 

[Trebby]

Try to provide examples along with the actual results you want to see. Note also that "didn't work" does not provide much to go on.

I agree - sorry working on a load of things here. I would of explained more later on. Thank you for your help guys.

 

[Aladin Akyurek]

Sorry if my post was explained that great

https://www.mediafire.com/?anb05fihf145hw5

In column E it should remain "10" until column D reaches "0". Once that happens E should then count down from 10. Both examples are pretty close to what I want. Use column C to enter days.

Such you can post directly here. But, more importantly, you are not giving examples where the actual (manually calculated) results are shown, rather, as you say, just the 'pretty close" results of the formulas already in the run.