I need to setup a nested if function in a few cells. I'm still learning excel and can't get it to compute correctly. I know it should be fairly easy. Basically the column with the conditions is a rank (1-50). Each rank has a dollar value placed on it. So I need the formula to read if condition=1 then $10, if condition=2 then $8, if condition=3 then $6, if condition = 4 then $4, if condition = 5-10 then $2, if condition equals 11-20 then $1, if condition equals 21-50 then $0.
Can anyone help on this? Tia.
Bookmarks