Whats Wrong With This Formula

I want to write an IF statement that has more than one IF,

=IF(D5>3,2, IF D5>1,1," ")

why am i getting an error???

Originally Posted by curly88

I want to write an IF statement that has more than one IF,

=IF(D5>3,2, IF D5>1,1," ")

why am i getting an error???

because you wrote it incorrectly

=IF(D5>3,2,IF(D5>1,1," "))

Thanks Bryan,

Those brackets make so much difference

I dont think my head is screwed on properly today, i have been forgetting everything

PROBLEM SOLVED THANKYOU

Originally Posted by curly88

Thanks Bryan,

Those brackets make so much difference

I dont think my head is screwed on properly today, i have been forgetting everything

PROBLEM SOLVED THANKYOU

Well, it IS Monday.