Grater then , less then with number range multiple

Solved/Closed
najustar72 Posts 2 Registration date Saturday August 2, 2014 Status Member Last seen August 3, 2014 - Aug 3, 2014 at 12:09 AM
najustar72 Posts 2 Registration date Saturday August 2, 2014 Status Member Last seen August 3, 2014 - Aug 3, 2014 at 03:12 AM
if the numbers cell A1<1 to >10 means the cell B1 have to calculate the C1 cell and if A1 <11 to >20 means the cell D1 have to calculate ......


please let clear this doubt

2 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Aug 3, 2014 at 01:40 AM
" A1<1 to >10 "
are you sure . did you ot mean

A1>1 and <10

what is meant by

"calculate the C1 cell"

what claculation?
1
najustar72 Posts 2 Registration date Saturday August 2, 2014 Status Member Last seen August 3, 2014
Aug 3, 2014 at 03:12 AM
=IF(AB17<=10,"10",IF(AB17<=20,"20",IF(AB17<=30,"30",IF(AB17<=31,"PENALTY",))))


Thanks I Got The Asnwer..
0