Thread: If again
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default 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