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.
=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.