Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2003

    Unanswered: IF returns FALSE, want empty (blank or zero)

    in cell E10 I have the fomula:

    it displays FALSE in E10 if C10 is empty. want E10 to be blank or zero if C10 is empty. Changing the format of E10 did not fix it.
    Last edited by rmatsler; 10-24-03 at 13:57.

  2. #2
    Join Date
    Oct 2003

    Re: IF returns FALSE, want empty (blank or zero)

    The formula is incomplete. The outer IF does not have a value on the failure of the condition.

    =IF(C10<>"",IF(OR(C9<>"",C8<>""),725,1450), 0)

    will now display a 0.

Posting Permissions

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