Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Lotus Display 0 if cell =0 after division

Status
Not open for further replies.

gofergofer

Technical User
Sep 22, 2006
1
US
I would like to have a cell display 0 if an other cell divided by X=0? Else display the results of the division?

Example I want a 0 displayed if F10/E10=0,0,else E10/F10

@IF(F10/E10=0,0,F10/E10)

Thanks in advance
gofergofer
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top