Previous Topic Next Topic

IF fuction

Solved/Closed
surbir - Apr 11, 2012 at 05:15 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Apr 11, 2012 at 07:19 PM
Hello,
I would like to right this formula
=IF(d5677="Maromix","RESIN-1925",IF(D5677="Marble" or "onyx" or "matamix" or "decoration","RESIN-1600","CHECK")))
like this but not success so please help me

Thanks



1 response

Answer 1 / 1
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 11, 2012 at 05:50 AM
try this


=IF(d5677="Maromix","RESIN-1925",IF(OR(D5677="Marble",D5677="onyx",D5677="matamix",D5677="decoration"),"RESIN-1600","CHECK"))
0
surbir
Apr 11, 2012 at 06:49 AM
Thank you very much,
it is very helpful for me

Thanks again
0
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Apr 11, 2012 at 07:19 PM
glad to help. Good luck
0