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!

Register Log in
  • 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

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.

Similar threads

doktor
  • Locked
  • Question
After the certification - how to obtain the diploma..
Replies
1
Views
91
burtsbees
burtsbees
Bizzarro
  • Locked
  • Question
Lotus 8.5 Certification LOT-953 Application Development Intermediate
Replies
0
Views
41
Bizzarro
Bizzarro
Tron626
  • Locked
  • Question
After A+... where do I go next...
Replies
5
Views
50
burtsbees
burtsbees
ionracing1979
  • Locked
  • Question
Microsoft 070-686 Training Kit
Replies
1
Views
66
kmcferrin
kmcferrin
mikechambers46
  • Locked
  • Question
Where do I go with CISSP after training?
Replies
0
Views
81
mikechambers46
mikechambers46

Part and Inventory Search

Sponsor

Back
Top