Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel IF/OR formula question
#3
IF does not take wildcards, but this may help:

=IF(OR(RIGHT(C12,5)="Close",RIGHT(C12,5)="Short"),7,"")

substitute smileys with closing parenthesis Smile

Good Luck!!...
Reply


Messages In This Thread
Excel IF/OR formula question - by Fritz - 04-10-2010, 04:29 AM
Re: Excel IF/OR formula question - by rich in distress - 04-10-2010, 06:19 AM
Re: Excel IF/OR formula question - by Fritz - 04-10-2010, 03:20 PM
Re: Excel IF/OR formula question - by Greg - 04-10-2010, 04:37 PM
Re: Excel IF/OR formula question - by Fritz - 04-10-2010, 05:04 PM
Re: Excel IF/OR formula question - by Buzz - 04-10-2010, 10:50 PM
Re: Excel IF/OR formula question - by Fritz - 04-11-2010, 05:32 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)