Results 1 to 3 of 3

Thread: FALSE error in formula

  1. #1

    FALSE error in formula



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have this formula in a cell,the cell will display the total billed for a employee


    =IF($F22+$G22+$H22+$K22+$J22+$L22+$N22+$O22+$P22>=1,IF($C22="","ERROR",SUM($Q22,$M22,$I22)))
    I want the cell this formula is in to be blank instead of saying false even if the arguments are not met


    basically it is saying : if cells f22 through p22 are greater than or equal to 1 and if c22 is blank then show error otherwise do the sum of q m and i 22

    now the formula works fine when a number is entered into f22-p22 which makes it greater then or equal to 1 without c22 having a name in it it shows an error letting the user know that they forgot the name or have entered the values in the wrong cell. which is what i want it to do

    however when the cells f22 through p22 have no input and the cell c22 has no name it is giving a false. i do understand why ,its because the formula is not meeting the arguements it was asked to do,

    how can i have it show blank in the total cell even when the arguments are not being met.

  2. #2
    Super Moderator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,462
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Perhaps =IF(and($F22+$G22+$H22+$K22+$J22+$L22+$N22+$O22+$P22>=1,$C22=""),"ERROR",SUM($Q22,$M22,$I22)) OTH:" if cells f22 through p22 are greater than or equal to 1 and if c22 is blank then show error otherwise do the sum of q m and i 22" is not quite clear. Their sum could be larger than 1 although each individual cell light be smaller than 1

  3. #3
    Try

    =IF(AND(SUM($F22:$H22,$K22:$L22,$N22:$P22)>=1,$C22=""),"ERROR",SUM($Q22,$M22,$I22))

Posting Permissions

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