![]() |
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 |
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 |
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