Results 1 to 11 of 11

Why is formula with error?

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-02-2008
    Location
    EU
    MS-Off Ver
    MS Excel 2007 Professional version
    Posts
    232

    Question Why is formula with error?

    I would like to make logical formula rule in case 0 values in fields like
    H1/H2

    I try to do:
    =IF(H1>0 *OR H1>0;H1/H2;0)

    What is wrong with this logical formula.
    Seems OR can not be included in logical rule? *OR
    Is this correct?


    The same sample issue:
    =IF(F16=0;TODAY()-E16;F16-E16)

    I like to do in this case AND operator inside formula:
    =IF(F16=0 AND E16=0;TODAY()-E16;F16-E16)
    Last edited by toplisek; 01-09-2010 at 09:11 AM.

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