ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   If Statements (https://www.excelbanter.com/excel-worksheet-functions/139114-if-statements.html)

Motaad

If Statements
 
I need to embed an if/and statement that has more than two conditions.: i.e.
if h2=h3 and (K3=9,K2=7),"9-8"

In other words, I need three conditions to apply to each if statement. Is
that possible and how would I do that?


--
Motaad

David Biddulph[_2_]

If Statements
 
=IF(AND(H2=H3,K3=9,K2=7),"9-8","answer if false")
--
David Biddulph

"Motaad" wrote in message
...
I need to embed an if/and statement that has more than two conditions.:
i.e.
if h2=h3 and (K3=9,K2=7),"9-8"

In other words, I need three conditions to apply to each if statement. Is
that possible and how would I do that?


--
Motaad




Toppers

If Statements
 
=IF(AND(H2=H3,K3=9,K2=7),"9-8","")

"Motaad" wrote:

I need to embed an if/and statement that has more than two conditions.: i.e.
if h2=h3 and (K3=9,K2=7),"9-8"

In other words, I need three conditions to apply to each if statement. Is
that possible and how would I do that?


--
Motaad



All times are GMT +1. The time now is 07:20 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com