# IF formula with multiple conditions - can't fix it

#### dulsie

##### New Member
Hi!

I am having troubles with an IF formula with multiple conditions.

This one works fine :

=ROUND(IF(AND([@[Distribution JJ]]="noos - first fill",[@[Distribution 760]]="noos - first fill",[@[Distribution BST]]="noos - first fill",[@[Distribution ONS]]="NOOS - FIRST FILL"),([@[Total bought (if NOOS) - min 600 units]]-[@[Sub Total ALL]])*'Buying Budget'!\$Y\$7,IF(AND([@[Distribution JJ]]="noos - first fill",[@[Distribution 760]]="noos - first fill",[@[Distribution BST]]=""),([@[Total bought (if NOOS) - min 600 units]]-[@[Sub Total ALL]])*'Buying Budget'!\$Z\$7,IF(AND([@[Distribution JJ]]="",[@[Distribution 760]]="",[@[Distribution BST]]="NOOS - FIRST FILL",[@[Distribution ONS]]="NOOS - FIRST FILL"),([@[Total bought (if NOOS) - min 600 units]]-[@[Sub Total ALL]])*'Buying Budget'!\$AA\$7,IF(AND([@[Distribution JJ]]="noos - first fill",[@[Distribution 760]]="noos - first fill",[@[Distribution BST]]="",[@[Distribution ONS]]="NOOS - FIRST FILL"),([@[Total bought (if NOOS) - min 600 units]]-[@[Sub Total ALL]])*'Buying Budget'!\$AB\$7,0)))),0)

But, when all these criterias are not met, I want to proceed with this formula :

I have tried to simply replace the last 0 in the first formula (highlighted in red) with this formula but it doesn't work. I am completely lost

Is there a genius here who could help me with this please? (I am sure there iiiiis!)

Thanks a lot.

### Excel Facts

When they said...
When they said you are going to "Excel at life", they meant you "will be doing Excel your whole life".

#### cerfani

##### Well-known Member
when i pasted your formula into a blank workbook I got an error for the syntax of those names being incorrect... maybe because the name has a space??

what error message do you get?

Last edited:

Replies
0
Views
54
Replies
2
Views
192
Replies
3
Views
80
Replies
1
Views
100
Replies
0
Views
209

1,109,341
Messages
5,528,147
Members
409,804
Latest member
aceyus_michael

### This Week's Hot Topics

• Change military grades into rank
Afternoon all Need help with formula that will change military rank (i.e. 1, 2, 3 into Amn, A1C, SrA). Running IF formula that does not work...
• VBA COUNTIF SOLUTION
Hi The following are the errors spread across the several columns from E to Q ie. 13 columns across several sheets with more than 500 rows per...
• INSERT ROW WITH SPECIFIS TEXT IN A COLUMN
Hi All! How can identify that that the row to be inserted has to be inserted before 1st row with specific text in column F. If I record the...