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