If again

[jamalhakem]

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

 

[Pete_UK]

What formulae do you have in D and F?

Pete

 

[jamalhakem]

What formulae do you have in D and F?

Pete



- 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

 

[Pete_UK]

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