Thread: Having a few problems If functions and using 'or'
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
robert111 robert111 is offline
external usenet poster
  
Posts: 1
Default Having a few problems If functions and using 'or'

=if(or(o18<n18*1.1,o18<m18*1.1,o18<l18*1.1)=1,"yes ","no")

this does it for 3 columns, you can have up to 30 in there


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=560601

Reply With QuoteReply With Quote