+ Reply to Thread
Results 1 to 2 of 2

Conditional Formatting when cell MAY equal ZERO

  1. #1
    Registered User
    Join Date
    06-19-2012
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    1

    Conditional Formatting when cell MAY equal ZERO

    This is probably a pretty simple fix, but I have racked my brain for days and just need to get it fixed!

    I have a document where I want to divide row B by Row C. About 50% of the time, Row C is going to be a zero, and gives me the #DIV/0 result.

    What conditional formula can I use to tell excel to make it first divide Row B by Row C, unless Row C equals zero, in which case divide Row B by .1.

    Hopefully that makes sense :-)

    Thanks!

    Momo

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Conditional Formatting when cell MAY equal ZERO

    Hi Momo, welcome to the forum. You could try:

    =IF(C2=0,B2/.1,B2/C2)

    Hope that helps!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1