Results 1 to 11 of 11

Why is formula with error?

Threaded View

toplisek Why is formula with error? 01-09-2010, 09:01 AM
DonkeyOte Re: Why is formula with error? 01-09-2010, 09:06 AM
toplisek Re: Why is formula with error? 01-09-2010, 09:17 AM
DonkeyOte Re: Why is formula with error? 01-09-2010, 10:06 AM
toplisek Re: Why is formula with error? 01-09-2010, 04:24 PM
DonkeyOte Re: Why is formula with error? 01-09-2010, 04:26 PM
martindwilson Re: Why is formula with error? 01-09-2010, 12:37 PM
toplisek Re: Why is formula with error? 01-09-2010, 04:31 PM
toplisek Re: Why is formula with error? 01-09-2010, 04:33 PM
toplisek Re: Calculation of delay in... 01-13-2010, 06:15 AM
martindwilson Re: Why is formula with error? 01-13-2010, 07:58 AM
  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