FALSE error in formula

grapplerca2014

New member
Joined
Feb 15, 2014
Messages
3
Reaction score
0
Points
0
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.
 
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
 
Try

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