I want to create a formula that returns three possible results.
Such as:
Cell C4 can have a result of anywhere from 0 to 30.
I want the adjacent cell, say D4, to return a value of 10 if cell C4 has a value between 20 and 30; return a value of 5 if cell C4 has a value between 10 and 19; and return a value of 0 if cell C4 has a value between 0 and 9.
Such as:
Cell C4 can have a result of anywhere from 0 to 30.
I want the adjacent cell, say D4, to return a value of 10 if cell C4 has a value between 20 and 30; return a value of 5 if cell C4 has a value between 10 and 19; and return a value of 0 if cell C4 has a value between 0 and 9.