Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel IF/OR formula question
#2
You need to use nested IF statements:

=if(C12="* Close",7,if(C12="* Short",7,0))

EDIT: Left off a closing parenthesis.
EDIT: My formula assumes it is located in cell Q12. If it is not, the statement becomes:

=if(C12="* Close",Q12="7",if(C12="* Short",Q12=7,0))
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 N-OS X-tasy! - 04-10-2010, 05:00 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)