0

All of my cells have formulas linking to other cells and sheets within a spreadsheet I have created, therefore none of my cells are 'empty'.

I have researched extensively but I cannot work out a formula to have cells be blank when other cells are blank (but not empty as they have a formula). Any advice, I have tried the following:

IF((C15<0)," ",($B15*$C15))
IF(ISNUMBER(SEARCH("%",C15))," ",($B15*$C15))
IF(ISBLANK(C15)," ", ($B15*$C15))

screenshot of my spreadsheet

Hariom Singh
  • 3,512
  • 6
  • 28
  • 52
Mikaela
  • 1
  • 2
  • Are your formulas putting a string containing a space or an empty string with nothing inside? – Jerry Jeremiah Aug 14 '17 at 00:38
  • I do not understand the question - the formula should bring back a number unless I've asked it not to due to another cell being blank (although its coming back with 'VALUE because the cell is not empty) – Mikaela Aug 14 '17 at 00:42
  • possible duplicate of https://stackoverflow.com/questions/1119614/return-empty-cell-from-formula-in-excel and https://stackoverflow.com/questions/18881053/how-to-make-an-excel-cell-equal-to-empty-possibly-via-vba-code Also related: https://stackoverflow.com/questions/18768020/if-statement-how-to-leave-cell-blank-if-condition-is-false-does-not-work – Jerry Jeremiah Aug 14 '17 at 00:45
  • And this: https://superuser.com/questions/837038/excel-how-to-create-truly-blank-cells-from-formula-so-that-they-wont-show-up The number format answer might do what you want. – Jerry Jeremiah Aug 14 '17 at 00:49
  • thank you, I will check it out – Mikaela Aug 14 '17 at 01:28

0 Answers0