That would make the formula unreadable!

An alternative suggestion :
use Insert Name and create a name MYTEST with this formula
=(Sheet1!$H$5="sell")*(Sheet1!$K$5-Sheet1!$M$5)+(Sheet1!$H$5<"sell")*(Sheet1!$N$5-Sheet1!$K$5)
Omit the Sheet1 stuff when you type it in - copy and paste this:
=($H$5="sell")*($K$5-$M$5)+($H$5<"sell")*($N$5-$K$5)

Now modify your Formula1 to read
Formula1=IF(OR(AND(K5<2;MYTEST<=-0.25);AND(K5=2;MYTEST<=5;MYTEST<=-0.4);AND(K55;K5<=10;MYTEST<=-0.5);AND(K510;K5<=20;MYTEST<=-0.8);AND(K520;MYTEST<=-1));"Check";"")

I had to make up an addition formula in Insert | Name since you cannot use
IF in a defined formula.
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"carl" wrote in message
...
I have these 2 formulas:


Formula1=IF(OR(AND(K5<2;F5<=-0.25);AND(K5=2;K5<=5;F5<=-0.4);AND(K55;K5<=10;F5<=-0.5);AND(K510;K5<=20;F5<=-0.8);AND(K520;F5<=-1));"Check";"")

Formula2=IF(H5="sell";K5-M5;N5-K5)

Formula2 is used in Formula1 where F5 is referenced. Is it possible to
place
formula 2 into formula1 directly so I do not need an additional cell
refernced ?

Thank you in advance.