IF function not working as expected

[anande]

I am having issues getting a formula to work. The objective is to get a percentage to show on B only if there is data entered into D and E. I was attempting to do so with IF. The first issue is that I cant get it to rely on both cells being blank it will only work if one is. I believe this can be cured with nested IF but have not tried yet. If it is not possible I can work with the formula relying on D as the blank cell. The second most major issue is that the cell is automatically going to the equation and showing 100% when the input cells are blank. The Formula used is this: =IF(D10=" ","(636-((D11*12)+E11))/636"," ")

[protonLeah]

1. You should have copy/pasted the actual formula from the cell.
2. You are using the word 'blank'; however, you are testing for a space, (" ") in the formula. A (" ") is an actual character just like the rest of those you see here.
3. Your formula is saying: IF there is a space character in D10, insert the character string "(636-((D11*12)+E11))/636", * Notice that the quotes make this a character string, not a formula to be calculated/evaluated. *, ELSE write a space character (" ") to the cell with the formula.
4. One way to check if two cells are empty, i.e. (""):

Please Login or Register  to view this content.