HOW DO I USE AN IF FORMULA THEN PUT A VALUE

HOW DO I WRITE A FORMULA FOR THE FOLLOWING. IF CELL F16 DIVIDED BY CELL E6
IF A VALUE OF LESS THAN ZERO THEN PUT A ZERO 0 IN THAT CELL.

I THINK THE START IS
=IF (F16/E6=<0

NOT SURE FROM HERE.

It depends on what you want in case F16/E6 is NOT less than zero......if you
want the resultant in that case then you can use:

=IF(F16/E6<0,0,F16/E6)

Vaya con Dios,
Chuck, CABGx3





"RTS_LORI" <[email protected]> wrote in message
news:[email protected]...
> HOW DO I WRITE A FORMULA FOR THE FOLLOWING. IF CELL F16 DIVIDED BY CELL
E6
> IF A VALUE OF LESS THAN ZERO THEN PUT A ZERO 0 IN THAT CELL.
>
> I THINK THE START IS
> =IF (F16/E6=<0
>
> NOT SURE FROM HERE.

Try this:

=MAX(F16/E6,0)

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"RTS_LORI" <[email protected]> wrote in message
news:[email protected]...
> HOW DO I WRITE A FORMULA FOR THE FOLLOWING. IF CELL F16 DIVIDED BY CELL
E6
> IF A VALUE OF LESS THAN ZERO THEN PUT A ZERO 0 IN THAT CELL.
>
> I THINK THE START IS
> =IF (F16/E6=<0
>
> NOT SURE FROM HERE.