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

JamesW

Well-known Member

Joined

Oct 30, 2009

Messages

1,197

• Mar 17, 2011

• #2

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

VoG

Legend

Joined

Jun 19, 2002

Messages

63,650

• Mar 17, 2011

• #3

Try removing the quotes

=IF(W11=0,"",X11/W11)

 

Upvote 0

Jonmo1

MrExcel MVP

Joined

Oct 12, 2006

Messages

44,061

• Mar 17, 2011

• #4

If that didn't work, perhaps some more detail is required.

Perhaps post the formula you have in W11

 

Upvote 0