Thread: Some Help Needed on getting info out of a cell from a formula
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.newusers
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Some Help Needed on getting info out of a cell from a formula
Thanks RD

Should have said "blank" in C7 returns ""

Originally read "in certain cells there is nothing to compute" and took that as
blank.

Maybe better would be =IF(OR(C7="",(C7=0)),"",(B7/2/C7))


Gord

On Sun, 2 Dec 2007 18:42:58 -0800, "Ragdyer" wrote:

<<< 0 or blank in C7 returns ""

Not in my XL97 Gord.

Reply With QuoteReply With Quote