Results 1 to 9 of 9

Multiple IF THEN statements in one cell

Threaded View

  1. #5
    Valued Forum Contributor
    Join Date
    04-13-2011
    Location
    Ottawa, Canada
    MS-Off Ver
    365
    Posts
    1,101

    Re: Multiple IF THEN statements in one cell

    Hello faist001, I'm a visualize person, thus forgive me if I'm wrong. Try the code below.

     =IF(B3>0,(C3-B3)/B3,IF(C3>0,C3-(C3-0.1)/(C3*99),IF(OR(B3=0, C3=0), 0, "Formula Incomplete")))
    Last edited by dluhut; 02-13-2013 at 02:13 PM.

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