Difference From - return blank or zero

**JmyCrikitt** · 08-13-2018, 01:48 PM

Hi-

Thanks in advance for your assistance. Not exactly sure how to explain. I have a pivot to show the variance in cost by item bought at different locations but would like to return a zero or blank if one of warehouse has no purchases for comparison. Thank you. CW

**kersplash** · 08-14-2018, 02:49 AM

Can you attach a workbook showing your expected result.

Go Advanced -> Manage Attachments -> Upload

**JmyCrikitt** · 08-20-2018, 08:51 PM

Thanks for your reply and apologies for my late response.

File attached. Hope I did it right.

See comments under the grid.

Appreciate your assistance.

Thank you

**kersplash** · 08-20-2018, 09:18 PM

Can you attach a workbook, not an image?

**JmyCrikitt** · 08-22-2018, 01:04 AM

Hi here you go

Thank you

**kersplash** · 08-22-2018, 01:08 AM

It's not clear (to me) what you want the output to look like.

Mock it up in the attachment to show what the end result for your sample should look like.

**JmyCrikitt** · 08-28-2018, 08:56 PM

the Goal is to see if warehouse "AD" is buying better or worse than warehouse "OTH"

If there are no cases purchased or either warehouse I want column F to return blank.

Then I want col. F to calculate the total bottom line spend impact of warehouse AD.

See attached. Thanks

**JeteMc** · 09-03-2018, 02:05 PM

You could populate column H (starting with H12 and dragged down as far as needed) using:

Formula:

Please Login or Register  to view this content.

I12 and down could read: =IF(A12="Grand Total",SUM(I$11:I11),IFERROR(H12*B12,""))
Let us know if you have any questions.

Difference From - return blank or zero

LinkBack

Thread Tools

Rate This Thread

Display

Difference From - return blank or zero

Re: Difference From - return blank or zero

Re: Difference From - return blank or zero

Re: Difference From - return blank or zero

Re: Difference From - return blank or zero

Re: Difference From - return blank or zero

Re: Difference From - return blank or zero

Re: Difference From - return blank or zero

Thread Information

Users Browsing this Thread

Similar Threads

Return value for first consective blank cell, ignore proceeding blank cells

[SOLVED] If two cells are blank then return blank, else vlookup cell with populated data

[SOLVED] Cells in a range are all not blank, return maximum value (date), If 1 blank return 0

Return first non blank cell (cells have formulas that return blank)

calculating the difference of two values, leaving blank any blank rows.

[SOLVED] if the difference is less than or greater than 50 return value

If statement meant to return blank cells doesn't return blank cells?

Bookmarks

Bookmarks

Posting Permissions