MORE THAN ONE FUNCTION IN THE SAME CELL
How I can write this function for one cell
=IF(O9<-2%;1); IF(-1%<O9<-2%;2); IF(-1%<O9<2%;3); IF(2%<O9<6%;4); IF(O96%;5) More in detail I have to compare a value with 5 criteria and put the relevant number from 1 to 5 Thank you |
MORE THAN ONE FUNCTION IN THE SAME CELL
Hi
Something like this should do the trick: =IF(O9<-0.02,1,IF(O9<-0.01,2,IF(O9<2,3,IF(O9<0.06,4,5)))) Andy. "Papadopoulos Panagiotis" <Papadopoulos wrote in message ... How I can write this function for one cell =IF(O9<-2%;1); IF(-1%<O9<-2%;2); IF(-1%<O9<2%;3); IF(2%<O9<6%;4); IF(O96%;5) More in detail I have to compare a value with 5 criteria and put the relevant number from 1 to 5 Thank you |
All times are GMT +1. The time now is 02:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com