Show Values using IF function on Multiple Ranges

Hello

I am trying to use IF function to determine what value should be displayed in a specific column i.e. column H. My table ranges from F5: H201

I have numeric values in column F, and YES/NO in column G.

I am trying to achieve following:

1) If the Value in column F is either 0 or Blank, then column H should display 0.
2) If column F has a number greater than 0 and column G has "YES" then column H should pick the value from cell F2 in the same sheet.
3) If column F has a number greater than 0 and column G has "NO" then column H should pick the value from cell I2 in the same sheet.

I am able to get the parts 2) & 3) working with this formula -

=IF(ISNUMBER(SEARCH("YES",G5)),$F$2,$I$2)

or

=IF(F5<0,0,IF(G5="YES",F2,IF(G5="NO",I2)))

But I am struggling to get the first condition incorporated in the formula i.e. if the column F is 0 or Blank, then column H should display 0. Only if column F has a number greater than 0, then the 2) or 3) become applicable.

I would appreciate any help !

Thanks

Hello

I am attaching a sample sheet.

I have this formula in column H, where I expect to see a result based on Value in column F and Text in column G

=IF(F5<0,0,IF(G5="YES",F2,IF(G5="NO",I2)))

Thanks

Yes Glenn ..... thats it ! It works like a dream.

Thanks a lot!