From everything I've read, you should be able to enter up to 7 variables in 1 "if" statement. I'm just trying to do one with 3, but every time I do, it tells me it's too many arguments. Obviously I'm doing something wrong! Any thoughts?

=IF(B6="NO",A6,0,IF(B6="YES",A6,A6,IF(B6="USE",A6,A6)))