# Thread: FALSE error in formula

1. ## FALSE error in formula

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.  Reply With Quote

2. 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  Reply With Quote

3. Try

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

#### Posting Permissions

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