Help with IF formula.

[IDR-1]

Hello

 

Would anyone be able to help with an if formula? I'm trying to make a formula which returns a YES or a NO based on the value of a cell. Ideally if the cell is less than zero it would return a NO, and if its above zero would return a yes. Any help would be appreciated.

 

Thanks in advance.

 

 

[Pat Stanford]

Assuming the value you want to check is in cell A1 then the formula should be:

 

=IF(A1<0, 'No', 'Yes')

 

[IDR-1]

That worked, much appreciated Pat!!