If again
 

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

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

If again
 

On Dec 15, 7:40*pm, Pete_UK wrote:
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- Hide quoted text -

- Show quoted text -

Hi Pete
in D
=IF('sheet1'!$C$5="apl";IF('sheet1'!H9=12;Sheet1' !H9;"No");IF
('Sheet1'!H9=9;Sheet1!H9;"No"))
In F
=IF(OR(ISNUMBER(D9);ISNUMBER(E9));SUM(D9:E9);"")
Can you help
Thanks in Advance
Jam

If again
 

Another way of writing the formula in F is:

=IF(OR(D9="No";E9="");"";D9+E9)

(a bit shorter), so then your original formula can become:

=IF(F11="";"No";IF(AND($C$6="tech";F11<50);"No";IF (AND($C
$6="apl";F11<60);"No";"OK")))

although this refers to row 11 and the formula above refers to row 9.

Hope this helps.

Pete

On Dec 15, 5:46*pm, wrote:
Hi Pete
in D
=IF('sheet1'!$C$5="apl";IF('sheet1'!H9=12;Sheet1' !H9;"No");IF
('Sheet1'!H9=9;Sheet1!H9;"No"))
In F
=IF(OR(ISNUMBER(D9);ISNUMBER(E9));SUM(D9:E9);"")
Can you help
Thanks in Advance
Jam