Why and If statement works in Excel 2007 but fails to work in Excel 2010?

**Superfly1984** · 05-02-2013, 08:49 PM

Hello Excel friends apologize for the non formal introduction I do plan to stop by and introduce myself. Currently I am having an issue with a formula that was working for me in Excel 2007 but when I got home today the same formula in Excel 2010 came back with an error message "You entered to many arguments for this function". I am trying to populate a single cell with 3 different variable with the following forumula:

=if(H17>=B$11,"Admit","Reject",if(F17="Yes","Early Admission"))

I also tried referring the F17 cell first but same effect with to many arguments.

Thanks

**FDibbins** · 05-02-2013, 08:58 PM

Hi and welcome to the forum

I dont see how that would work in 2007 either, you have 4 arguments in the 1st and only 2 in the 2nd, an if statement only takes 3...

=if(H17>=B$11,.........."Admit",.........."Reject",..........if(F17="Yes",.........."Early Admission"..........?????????????))

=if(criteria-to-test,..........what-to-do-if-test=TRUE,..........what-to-do-if-test=FALSE)

**protonLeah** · 05-02-2013, 09:00 PM

That formula will not work in Excelx as written.
The "Reject" segment is the false condition and the If(F17.. clause does not belong.

You need something that looks like:

Please Login or Register  to view this content.

Notice that in the formula you posted, that the second If has no false condition.

**Tony Valko** · 05-02-2013, 09:01 PM

You have "Reject" out of place.

Maybe this is what you're after:

=IF(H17>=B$11,"Admit",IF(F17="Yes","Early Admission","Reject"))

**humdingaling** · 05-02-2013, 09:01 PM

if formula only has true or false

i re-arranged to what i think you are trying to do
if H17 > b11 then Admit otherwise if F17 = yes then reject otherwise early admission

Please Login or Register  to view this content.

**Superfly1984** · 05-03-2013, 08:06 AM

Thanks guys you are absolutely right I rearranged it the wrong way before where reject fell in as my false with Early Admit. Thanks everyone for helping me get this straight.