Error Messages

G

Graeme155

New Member
Joined
Jan 17, 2011
Messages
32
Hi

I have written a Getdata formula from a Pivot tables to show the Salesperson's Sales for the Month. When they did not make a sale this showed as #REF ! . Is there a way to change this to Zero or Blank?

Graeme :confused:
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Sort by date Sort by votes
You can alway use the if and ise:

Code: 
=IF(ISERROR(GETPIVOTDATA(B6;A5:B15));"";GETPIVOTDATA(B6;A5:B15))
 
Upvote 0
If Excel 2007+ try
=IFERROR(current formula,0)
or
"" instead of 0 if you want a blank

If Excel 2003- try
=IF(ISERROR(current formula),0,current formula)
or
"" instead of 0 ..
 
Upvote 0
You must log in or register to reply here.

Similar threads

T
  • Solved
Stop and start counting in different cells
Replies
9
Views
159
Turbos
T
D
  • Solved
Help with my Dynamic Top 10 Formula
Replies
7
Views
200
DanielJeff
D
D
  • Question Question
Divide Current Month into weeks
Replies
3
Views
327
Armstrong_N14
A
B
  • Question Question
Sorring multiple tables concurrently.
Replies
1
Views
163
MountainFog
M
F
  • Question Question
Pivot Tables and Porcentages
Replies
1
Views
358
GraH
GraH

Forum statistics

Threads
1,224,548
Messages
6,179,445
Members
452,915
Latest member
hannnahheileen

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top