Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

Question:

Question: Help with Code return “nothing value”

I have a sheet named “pricing”. And a sheet named “style 1”. On style 1 i have two tables. I have a cell in table 1 that i trying to get to reference a cell from Pricing. I can get. =Pricing :: ‘Table 1’ :: b22 To bring in anything I type into b22 in pricing. But, how do i get “nothing” to show up if there is nothing in b22 on pricing. Right now if nothing is in b22 in Priceing, a “0” show up in my cell on style 1

Posted on

Reply

Page content loaded

Mar 9, 2018 4:19 PM in response to Region Rat In response to Region Rat

Hi RR,


Try this:


=IF(LEN(Pricing::Table 1::B22)<1,"",Pricing::Table 1::B22)


Suggestion: Give each of the Tables in your document a distinct name. This will shorten your formulas, as Numbers will need only the Table name to locate the table, and the sheet name may be omitted (and will be discarded from formulas where it is not needed).


With the Table on Pricing named Prices, for example, the above formula would be:


=IF(LEN(Prices::B22)<1,"",Prices::B22)


Regards,

Barry

Mar 9, 2018 4:19 PM

Reply Helpful
User profile for user: Region Rat

Question: Help with Code return “nothing value”