IF Condition

[dodokh]

Hello

Please I need a help to make the following formula in cell H2:

https://www.dropbox.com/s/4lbuh0b07zdtand/Untitled.png?dl=0

If D2 = "In Progress" and F2 is less than 50% of E2 then H2=(E2*50%)-F2 (Value if false = 0)
and IF D2 = "Closed" and G2 is greater than zero then H2=G2 (Value if false = 0)

Thank in advance

 

[sgroath]

try this in H2:
=IFERROR(IF(AND(D2="In Progress",F2<E2/2),(E2/2)-F2,IF(AND(D2="Closed",G2>0),G2,0)),0)

 

[Scott Huish]

Thank you for posting a sample, but it would be easier for everyone if your download was an Excel spreadsheet so that we didn't have to recreate your sample.
Assuming your status is either In Progress or Closed, perhaps this:
=IF(D2="In Progress",IF(F2<E2/2,(E2/2)-F2,0),MAX(G2,0))

 

[sgroath]

not sure what happened with my formula - should have been:
<e2 2),(e2="" 2)-f2,if(and(d2="Closed" ,g2=""><e2 2),="" (e2="" 2)-f2,="" if(and(d2="Closed" ,g2=""><e2 2),(e2="" 2)-f2,if(and(d2="Closed" ,g2=""><e2 2),(e2="" 2)-f2,if(and(d2="Closed" ,g2=""><e2*.5),(e2*.5)-f2,if(and(d2="closed",g2>
=IFERROR(IF(AND(D2="In Progress",F2 < E2/2),(E2/2)-F2,IF(AND(D2="Closed",G2 > 0),G2,0)),0)

see if that works better</e2*.5),(e2*.5)-f2,if(and(d2="closed",g2></e2></e2></e2></e2>

 

[dodokh]

Thanks
Both work perfectly