Comments for Chandoo.org – Learn Excel, Power BI & Charting Online

Comment on Hui’s Excel Report Printer by Arpan Chakraborty

Arpan Chakraborty — Sat, 28 Mar 2026 09:18:41 +0000

Possible Cash Out
3500
2500
2000
3500
3500
2000
1500
2500
5000
2000

for IF formula i am geting this payout,here is my formula

=IF($C4=0%,1500,IF(AND($C4>0%,$C4<3%),1000,0))+IF(IF($E4<500,1000,0)=1000,1000,IF($F4=1,1000,0)+IF($D4>=98%,1500,IF($D4>=96%,500,0))+IF(AND($C4=96%,OR($E4<500,$F4<560),$G4=1),5000,0)

but for EMP0002 my answer is 2500 buy your answer is 2000.

Comment on Power Query Tutorial – What is it, How to use, Full examples, Tips & Tricks by Sanath Dissanayake

Sanath Dissanayake — Fri, 20 Mar 2026 16:49:14 +0000

Hi Chandoo,

Thank you very much for your great effort to help us learn these topics.

I found the content so useful and valuable.
Thank you again for sharing your knowledge.

Regards.

Sanath.

Comment on Write a formula to get Department Budget for a Month [Homework] by Shazia

Shazia — Wed, 11 Mar 2026 05:41:47 +0000

=XLOOKUP(D14:D18,budgets[Department],budgets[Apr])

Comment on Write a formula to get Department Budget for a Month [Homework] by Shazia

Shazia — Wed, 11 Mar 2026 05:35:27 +0000

Department Marketing
Month Apr

Budget Amount 41500

Comment on More than 3 Conditional Formats in Excel by Dave dillon

Dave dillon — Mon, 09 Mar 2026 09:41:55 +0000

=COUNTA(FILTER(B7:B16,ISNUMBER(XMATCH(B7:B16,C7:C16))))

Comment on More than 3 Conditional Formats in Excel by Manjunath J

Manjunath J — Mon, 09 Mar 2026 07:10:46 +0000

Assuming no duplicates in ListA and ListB, here is the formula.
=SUM(COUNTIFS($B$7:$B$16,"="&$A$7:$A$16))

Values start from A7 and B7.

Comment on Power Query Tutorial – What is it, How to use, Full examples, Tips & Tricks by Nayaz

Nayaz — Fri, 06 Mar 2026 21:19:54 +0000

In reply to Chandoo. Excellent fantastic and it helps me understand the concept of power query. excellent presentation