Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old April 11th 05, 04:00 PM
Stephen
 
Posts: n/a
Default Conditional Statement with ANDs

Hi. I'm trying to do the following:

Create a conditional statement where if a group of ideas are true, it will
produce the result. Meaning, if a6a5 and a5a4 and a4a3 then a6/a3, if
a5a4 and a4a3, then a5/a3, etc.

How can I do this??
Thanks!
--
Thanks!

Stephen

  #2   Report Post  
Old April 11th 05, 04:40 PM
Duke Carey
 
Posts: n/a
Default

=IF(AND(A6A5,A5A4),A6/A3,otherwise)

"Stephen" wrote:

Hi. I'm trying to do the following:

Create a conditional statement where if a group of ideas are true, it will
produce the result. Meaning, if a6a5 and a5a4 and a4a3 then a6/a3, if
a5a4 and a4a3, then a5/a3, etc.

How can I do this??
Thanks!
--
Thanks!

Stephen

  #3   Report Post  
Old April 11th 05, 04:41 PM
PCLIVE
 
Posts: n/a
Default

Try something like this:

=IF(AND(A6<A5,A5<A4,A4<A3),A6/A$3,)

After the comma at the end is what you want to return if the equation is
false.

HTH,
Paul

"Stephen" wrote in message
...
Hi. I'm trying to do the following:

Create a conditional statement where if a group of ideas are true, it will
produce the result. Meaning, if a6a5 and a5a4 and a4a3 then a6/a3, if
a5a4 and a4a3, then a5/a3, etc.

How can I do this??
Thanks!
--
Thanks!

Stephen





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
Trouble with a conditional statement Jim New Users to Excel 2 April 10th 05 10:13 PM
IF Statement that's conditional on multiple IF Stmts in other cell Pat Excel Worksheet Functions 1 March 26th 05 10:31 PM
=IF Statement formula or conditional formatting Abi Excel Worksheet Functions 6 January 18th 05 01:06 PM
How do I write a conditional statement in Excel to count if two c. marblelife Excel Worksheet Functions 2 January 16th 05 11:16 PM
Conditional if statement Matt Stanley Excel Worksheet Functions 2 November 10th 04 04:47 AM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017