How to remove #DIV/0! from what-if analysis data table?

E

excela2z

New Member
Joined
Mar 3, 2021
Messages
1
Office Version
  1. 2013
How do you remove #DIV/0! from what-if analysis data table?

The code in the cell is something like this =TABLE(C5,O1)

Tried adding the IFERROR(TABLE(C5,O1),"") but doesn't work
 

Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
Sort by date Sort by votes
In the formula. example: =IF(O1=0,"",C5/O1)
 
Upvote 0
You must log in or register to reply here.

Similar threads

Pinaceous
  • Solved
#DIV/0! error in excel
Replies
2
Views
270
Pinaceous
Pinaceous
KlausW
  • Solved
copy data from several closed workbooks to one workbook.
Replies
5
Views
680
KlausW
KlausW
S
  • Question
Trendline values using Dynamic Range in Excel - comparing with LINEST function
Replies
1
Views
187
Domenic
D
P
  • Question
Lock cells when text entered into another vba not working
Replies
0
Views
390
P4444
P
C
  • Question
VBA: Filter specific data from table then make formula and put result to summary workbook
Replies
1
Views
376
HighAndWilder
H

Forum statistics

Threads
1,214,642
Messages
6,120,698
Members
448,979
Latest member
DET4492

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