View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Blondie Blondie is offline
external usenet poster
 
Posts: 12
Default Can we have cells pop up with a formula & hide if not want

We have formulas in ourt spreadsheet in excel for building quotes. We also
have cells with Y or N that relate to formulas for y to have a beam and n to
not have the beam (as an example) and we want some way if possibe to have
only the cells that relate to the y to pop up and the other to not calculate
into our quote. Can this be done?