If again
What formulae do you have in D and F?
Pete
On Dec 15, 5:35*pm, wrote:
Hi
Any help
I have this formula
=IF(AND($C$6="tech";F11<50);"No";IF(AND($C$6="apl" ;F11<60);"No";"OK"))
D * * * * * * * E * * * * * * * F
Formula blank * * * * * formula
In D there is a formula giving the result from other sheet, this
result could be a number or a text
E is blank to be filled with numbers
In F is the sum of D and E if they are all number
My formula is giving “OK” even if there are no results in F
I want to add another If statement to give "" or blank if there is no
results in D, E, F, I of course tried istext function but of course it
does not work, since D and E contain formulas
Any help
Thanks in advance
Jam
|