=IF(W11="0","",X11/W11) where W11 is a formula

O

oomfh

Board Regular
Joined
Feb 17, 2011
Messages
141
W11 is a forumla, but when it is "0" I'm not getting ""

Still new(er) at this!!!
 

Excel Facts

Create a chart in one keystroke
Select the data and press Alt+F1 to insert a default chart. You can change the default chart to any chart type
Sort by date Sort by votes
Hi,

Do you really mean "0" (text value) or do you mean 0 (numeric value)?

If the latter: =IF(W11=0,"",X11/W11)
 
Upvote 0
If that didn't work, perhaps some more detail is required.

Perhaps post the formula you have in W11
 
Upvote 0
You must log in or register to reply here.

Similar threads

D
  • Solved
Cannot COUNT/SUM Displayed Table Values, Table Filtered Values Out of Order
Replies
3
Views
383
Alex Blakenburg
A
M
  • Solved
VBA code to get picture dimensions & DPI from selectable folder and it's subfolders
Replies
8
Views
1K
NdNoviceHlp
NdNoviceHlp
R
  • Question Question
Highlighting cells based on criteria
Replies
0
Views
436
rahildhody
R
S
  • Question Question
Inventory disposal plan
Replies
3
Views
298
Spaceballs_the_fanboy
S
W
  • Question Question
Copy formula across 28 day dynamic shift calendar
Replies
4
Views
346
Wolfgang17
W

Forum statistics

Threads
1,224,514
Messages
6,179,225
Members
452,896
Latest member
IGT

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