Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Need formula using ifs

Have a range of numbers 1 - 60. I want to make a choice depending on a range of numbers i.e. If the number is between 1 and 10 then do THIS if the number is between 11and 20 do THAT if the number is between 21 and 40 do SOMETHING ELSE if the number is between 41 and 50 do XYZ if the number is between 51 and 60 do ABC

The THIS/THATetc names relate to formula.