try this
=IF(A1>2.99,A1*1,IF(A1>2.79,A1*0.75,IF(A1>1.99,A1*0.5,A1*0)))
If A1 is the rating cell
try this
=IF(A1>2.99,A1*1,IF(A1>2.79,A1*0.75,IF(A1>1.99,A1*0.5,A1*0)))
If A1 is the rating cell
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks