I need help with a formula. I need C22 to return a value of O5 x C21, but the value of C22 should never be higher than the value in Z98 and never lower than the value in Z99. Right now, all I have in C22 is =O5*C21 but of course it returns higher than Z98 or lower than Z99 so my spreadsheet won't work. Can anyone help? Thanks in advance!