View Single Post
  #1   Report Post  
RTS_LORI
 
Posts: n/a
Default 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.