How to Combine IF statements in Excel

debugcn Published at Dev

Jose

The following formulas work individually but when I combine them I get a VALUE error, please help!

=IF(AND(LEFT(D7,14)="Cost Avoidance")*AND(AI7>=100000),"Yes, provide validation form in column AK","No")

=IF(AND(LEFT(D7,14)="Cost Reduction")*AND(AI7>=50000),"Yes, provide validation form in column AK","No")

Combined (doesn't work): =IF(LEFT(D7,14)="Cost Avoidance"*AND(AI7>=100000),"Yes, provide validation form in column AK",IF(LEFT(D7,14)="Cost Reduction"*AND(AI7>=50000),"Yes, provide validation form in column AK","No"))

Jose

=IF(AND(LEFT(D7,14)="Cost Avoidance",AI7>=100000),"Yes, provide validation form in column AK",IF(AND(LEFT(D7,14)="Cost Reduction",AI7>=50000),"Yes, provide validation form in column AK","No"))

Solved it on my own

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at2021-07-18

Comments

0 comments

From Dev

Related Related

Article

How to Combine IF statements in Excel

How to Combine IF statements in Excel

How can I combine these two if/else statements for different results?

How do i combine multiple select statements in separate columns?

How to combine two select statements in SQL Server

How can I combine these jQuery statements?

Perl regex: how do I combine these 2 regex statements?

How do I combine two pig statements into one?

how can combine the two sqlite statements into one statement?

How to combine multiple count statements in SQL

How do I combine two $and statements in an $or statement in mongodb?

How to Combine Two Extglob statements in Bash

How to combine Switch statements?

How do I combine these mysql statements

How to combine 2 SQL statements into one table

how to combine multiple if statements in one line python3

How to combine these two sql statements

How to combine three Select Statements using UNION

How can I combine these jQuery statements?

How to combine multiple count statements in SQL

How to combine conditional statements in Lotus Notes formula language?

How can I combine these two statements?

Combine two long IF statements on Excel into one formula

How to combine these 2 ng-class statements?

How to combine increment and decrement statements into one single statements

How to combine Switch statements?

How do I combine these two while statements into one?

How to combine these sql queries in Excel

How to combine two SQL SELECT statements in one?

How to combine two select statements in c++

how to combine multiple IF in ms excel