greater than, equal to. less than

Hi,
I am trying to get a formulae for looking at the value of a cell and depending if less than or equal to or equal to or greater than to put the resulting value into the next cell If I use =IF(H$10<=$F10,($F$10/$C$10*i8)) this gives me the less than or equal to, how do I get the next part of the equation into the formulae.the greater than (H$10>=$F10,($F$10/$C$) I am new to this and cannot figure out how to get the second part into the formulae into the cell.

Many thanks

robbosan

Put $F$10/$C$ in the ValueIfFalse part of the if..

=IF(condition,ValueIfTrue,ValueIfFalse)

Your formula has only the ValueIfTrue part.
=IF(H$10<=$F10, ($F$10/$C$10*i8))

When the ValueIfFalse is omitted, it just returns FALSE..

Try
=IF(H$10<=$F10, ($F$10/$C$10*i8),$F$10/$C$)