Posted to microsoft.public.excel.worksheet.functions

carl

Posts: n/a

Combining 2 Formulas

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.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Countif formulas change after doing a sort	Bob Smith	Excel Worksheet Functions	3	January 3rd 06 11:17 PM
Array Formulas take waaaay too long...	belly0fdesire	Excel Worksheet Functions	7	August 8th 05 10:11 PM
Combining two formulas	Redsmartie	Excel Worksheet Functions	2	April 7th 05 09:52 AM
Combining formulas and results HELP!!	JRH	New Users to Excel	4	January 22nd 05 05:26 PM
combining countif formulas	Liz G	Excel Worksheet Functions	3	November 1st 04 09:34 PM

All times are GMT +1. The time now is 06:04 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us