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]

Try changing "0" to 0
=(IFERROR(IF(F8>20,"0",IF(F8<20,SUM(20-F8))),""))

Also, you are checking if G8>=0 then if G8=0 can't be both? Maybe, G8<>0 then G8=0

 

[Trebby]

Try changing "0" to 0
=(IFERROR(IF(F8>20,"0",IF(F8<20,SUM(20-F8))),""))

Thanks for the reply. Unfortunately still getting the same outcome. F8 has 22, G8 has 0 (as more than 20) and H8 has returned 10 (when should be 8).

 

[gaz_chops]

Check my edited reply.

 

[Trebby]

Check my edited reply.

Yeah I see that - I tried =IF(G8<=20,10,IF(G8=0,SUM(E8-20))) same issue, again I'm asking 2 things from one cell.

 

[gaz_chops]

Your 1st formula prob should be, as you don't allow for if it is 20
=(IFERROR(IF(F8>=20,0,IF(F8<20,SUM(20-F8))),""))
2nd one prob
=IF(G8>0,10,IF(G8=0,SUM(E8-20)))

 

[gaz_chops]

Also, 10 appears correct! E8-20=10 (E8=30)

 

[Trebby]

Your 1st formula prob should be, as you don't allow for if it is 20
=(IFERROR(IF(F8>=20,0,IF(F8<20,SUM(20-F8))),""))
2nd one prob
=IF(G8>0,10,IF(G8=0,SUM(E8-20)))

I was able to do something with condition formatting (not ideal) but it worked. Thank you#

 

[gaz_chops]

With conditional formatting? Did you fix the formula?

 

[Trebby]

Also, 10 appears correct! E8-20=10 (E8=30)

Good point ... lol... I did try it with another cell and it still didn't work. It's OK I've managed to activate them cells when under 10.