Hi-
I am new to excel functions (if, or, and, etc). I am trying to create a function that has the following statements embedded in one function:
if x and 1st=96
if x and 2nd=25
if no x and 1st=25
if no x and 2nd=0
I tried to used the formula below, but I have received the error message that the fuction has too many arguments.
=IF(AND(D13="x", $F$11="1st"), 96, (AND(D13="x", $F$11="2nd")), 25,OR(IF(AND(D13=" ", $F$11="1st"))), 25, (AND(D13=" ", $F$11="2nd"), 0))
Any assistance is much appreciated.
Bookmarks