HOW DO I USE AN IF FORMULA THEN PUT A VALUE
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" wrote in message
...
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.
|