Author Topic: Help with Google Drive sheets  (Read 685 times)

Offline KidOOO

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Oct 2011
  • Posts: 1774
  • Total likes: 8
  • DansDeals.com Hat Tips 2
  • Gender: Male
    • View Profile
  • Location: NY
Help with Google Drive sheets
« on: April 27, 2014, 11:06:13 AM »
I want the formula results to show only when there are values in the cells that are being calculated

so the rows that i haven't added any values yet should not show anything (although the formula is active on those lines) until i enter values

Any idea how to do this?

Offline bubbles

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jul 2011
  • Posts: 5055
  • Total likes: 17
  • DansDeals.com Hat Tips 67
    • View Profile
Re: Help with Google Drive sheets
« Reply #1 on: April 27, 2014, 11:21:45 AM »
Not sure I follow. something like this?
=if(a1<>"",formula,"")