Using IF function within QUERY formulas (Google Sheet)

Question

all.

I'm working on a stacked bar chart showing my trading P/L, with the green bars showing gains while the red bars showing losses. But as you can see in the image (attached), the data labels for the red bars show up on the RH side if it's $0, which I want to get rid of. I figured I should use an IF formula within the query formula (on cell G1) so that the if a cell returns "$0.00", it should remain an empty cell. However, after a few trials, I still couldn't get it to work. I appreciate anyone who can take a look at my spreadsheet (linked below) and see what's the best solution for this. Sheet 2 is editable.

https://docs.google.com/spreadsheets/d/1YzuJGVDJ7rZ7PTkJpJCHA27QUiMqXQnP6dI_ZplYWG0/edit?usp=sharing

Image: Stacked Bar Chart

Thanks! J

Rocky · Accepted Answer · 2020-12-17 08:03:33Z

2

It is possible by using the customized number format

Naviagtion : - Data Ranage >>Customized>>Number Format>>Other Custom Formats

Use - #,##.##

edited Dec 17, 2020 at 8:03

answered Dec 17, 2020 at 7:52

Rocky

9901 gold badge7 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Using IF function within QUERY formulas (Google Sheet)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related