Complicated IF formula

Hello @LoganCraft

I recommend breaking down each piece of the function to make sure they are entered in correctly.

Off the bat, your second OR function (First condition) ends after "Expired" and then you close the second IF function immediately.

IF(OR([Application Status]@row = "Declined", [Application Status]@row = "Withdrawn", [Application Status]@row = "Expired"), 0)

You have a condition and when it's true, enter 0, with no false statement (which is ok). Then you immediately close the IF statement. This will result in, If the application status is one of these options, enter 0, or false. Which is technically the same thing if the column is a Boolean, but the function will error if you are mixing the results of variable types. A Text/Number column would display FALSE, if the IF function resulted in a false statement. If you are looking for the number 0 to apply to something else, you will error every function using that value. Such as a SUM(1,0)=1. SUM(FALSE,0) is an error.

Break it down into individual IF statements and then piece them together. Make sure each function works before you nest it into another function.

I don't typically open with a OR statement, give this a try.

=IF(OR([Application Status]@row = "Declined", [Application Status]@row = "Withdrawn", [Application Status]@row = "Expired"), 0, IF([PLTW Course Teacher was Trained In]@row = "Launch Classroom Teacher Training", 500, IF([PLTW Course Teacher was Trained In]@row = "Launch Lead Teacher Training", 700, IF(OR([PLTW Course Teacher was Trained In]@row = "Energy and the Environment", [PLTW Course Teacher was Trained In]@row = "Green Architecture", [PLTW Course Teacher was Trained In]@row = "Magic of Electrons", [PLTW Course Teacher was Trained In]@row = "Science of Technology"), 750, IF(OR([PLTW Course Teacher was Trained In]@row = "App Creators", [PLTW Course Teacher was Trained In]@row = "Automation and Robotics", [PLTW Course Teacher was Trained In]@row = "Computer Science for Innovators and Makers", [PLTW Course Teacher was Trained In]@row = "Design and Modeling", [PLTW Course Teacher was Trained In]@row = "Flight and Space", [PLTW Course Teacher was Trained In]@row = "Medical Detectives"), 1200, 2400)))))