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"))
surbir
Apr 11, 2012 at 06:49 AM
Thank you very much,
it is very helpful for me

Thanks again
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