# CP026: All about Excel !@#\$%^+/*(}][<

In the 26th session of Chandoo.org podcast, let’s learn all about Excel !@#\$%^+/*(}][<.

I am talking about Excel operators, you silly.

### What is in this session?

Do you know Excel has more than 25 operators? That is right. There are a variety of operators beyond the simple + – * and /.

In this podcast, let’s understand all about these operators and how to use them. You will learn,

• Why there is a gap between last & this podcast session
• Arithmetic operators
• Text operators
• Reference operators
• Comparison operators
• Closing thoughts

### Links & Resources on Excel operators & Formulas

Excel Dashboard Templates

### What are your favorite Excel operators?

My favorites are % ? * and []

### Subscribe to Chandoo.org Podcast

Other options to subscribe

Hello Awesome...

My name is Chandoo. Thanks for dropping by. My mission is to make you awesome in Excel & your work. I live in Wellington, New Zealand. When I am not F9ing my formulas, I cycle, cook or play lego with my kids. Know more about me.

Thank you and see you around.

### Related articles:

 Written by Chandoo Tags: Excel 101, intersection operator, Learn Excel, logical operators in excel, Microsoft Excel Formulas, podcast, wildcards in excel Home: Chandoo.org Main Page ? Doubt: Ask an Excel Question

### 6 Responses to “CP026: All about Excel !@#\$%^+/*(}][<”

1. Amol Pandey says:

Hi Chandoo,

The topic is very interesting, and I liked your podcast. But it would be it be really great if you can look forward to post a video on it. Video would be much easier to follow through along for complex topics.

Thanks
Amol

2. Sanjib says:

Hi Chandoo,

Is there a way to select the named range (say javed) directly with any formulae.
For eg I want to know Javed's Sale in month of Apr.
I put two data validated input cell ( with list inputs), and then in an output cell refer:-
"named range javed auto selected as per input cell" "space operator" "named range apr auto selected as per input cell" to get the final result.
Can it be done?

Thanks
Sanjib

• istiyak says:

Hi Sajib,

Can you post the sample workbook.? So atleast we can work on that and give you a proper solution.

regards
istiyak

• Jake Collins says:

use something like =INDIRECT(M20) INDIRECT(N20) where m20 and n20 are the input cells

• Sanjib says:

Thank you Jake, that works.
And this can help me a lot.

Chandoo.org and all its members .. you are awesome !!

Enjoy !

Sanjib

3. Mayank says:

Thanks for nice topic. Covered very well.

 « Creating In-cell charts with markers for average (or target) values Excel Links – 2014 Holiday Sale Edition »

### Get FREE Excel & Power-BI Newsletter

One email per week with Excel and Power BI goodness. Join 100,000+ others and get it free.