Posted to microsoft.public.excel.worksheet.functions

Hillary: needing some help[_2_] is offline

external usenet poster

Posts: 7

combining IF, AND, and OR Functions

thank you!!

"Mike H" wrote:

Hi,

Try this

=IF(AND(G90,F9E9),"Hold",IF(OR(F9<E9,F9<E9*1.035 ),"Sell",""))

Mike

"Hillary: needing some help" wrote:

=IF(G90,
AND(F9=E9,"HOLD",
IF(F9<E9,
OR(F9<E9*1.035,"SELL"))))

not sure how to make this work

=IF(G90,AND(F9=E9,"HOLD",IF(F9<E9,OR(F9<E9*1.035 ,"SELL"))))
as one line it doesn't work how can I order it to where it will work

thanks

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
Combining Functions	MikeM	Excel Discussion (Misc queries)	5	October 16th 08 02:31 PM
Combining Functions	MikeM	Excel Discussion (Misc queries)	3	September 30th 08 04:52 PM
Combining functions AND and OR	Jan Buckley	Excel Worksheet Functions	3	November 14th 06 05:21 PM
Combining IF OR and AND functions	andyp161	Excel Worksheet Functions	3	April 20th 06 06:05 PM
Combining functions	Steve	Excel Worksheet Functions	2	March 31st 06 05:49 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us