Formulas can't do that kind of thing.

But there are workarounds. There are worksheet events that can be on the
lookout for a value in a cell. And that can be just as effective.



Luke Vogel wrote:

I'm trying to do a similar thing ...

Is it feasible to execute a similar macro from within a if() function?

Luke.

"Don Guillett" wrote in message
...
you can use datafilter to hide rows. Suggest a macro to hide the rows and
columns based on your criteria.

for each c in selection
if c=1 then rows("1:5").hidden=true
etc
next

--
Don Guillett
SalesAid Software

"Sqwilly" wrote in message
...
I have created a bid template that calculates a price based on the count
that
I give it
Example: 22 item abc $45
$990
12 item cba $12
$144
if the item count is 0, I would like it to hide that row, and when I
print
the bid, I would like to have the option to hide the columns for unit
price
and total price for all items.



--

Dave Peterson