#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3,942
Default Combining Functions

hi
your information is sketchy so the answer may seem just as vague.

but yes there is a way.....

=if(and(condition1,conditon2),I81, I812)

regards
FSt1

"MikeM" wrote:

Is there a way to combine the "IF" function and the "AND" function in one
formula, when I want to return a value from another cell as opposed to a
"true" or "false", is this possible?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 IF & AND functions Khoshravan Excel Discussion (Misc queries) 5 October 3rd 07 12:12 AM
Combining functions AND and OR Jan Buckley Excel Worksheet Functions 3 November 14th 06 05:21 PM
Combining IF and OR Functions ConfusedNHouston Excel Discussion (Misc queries) 2 October 4th 06 12:38 AM
Combining IF OR and AND functions andyp161 Excel Worksheet Functions 3 April 20th 06 06:05 PM


All times are GMT +1. The time now is 02:14 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"