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?

 

[gaz_chops]

With the data you show, D can never reach 0?

 

[Trebby]

With the data you show, D can never reach 0?

If you enter 20 in Cells C4 or C10 then D4 or D10 will return 0.

 

[Trebby]

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.

If you enter "24" in cell C10 you will see what I'm trying to achieve. Unfortunately if you enter anything below "20" in cell C10, E10 then counts up but I need to to stay at 10.

 

[Aladin Akyurek]

If you enter "24" in cell C10 you will see what I'm trying to achieve. Unfortunately if you enter anything below "20" in cell C10, E10 then counts up but I need to to stay at 10.

I'm afraid you missed my point. I'm not interested at all what these formulas do... You need to create a set of examples, forget about the formulas, and report the manually calculated results you are after.