spread sheet #VALUE!

New Contributor

hi, I am working on an assignment for college in the spread sheet app and i am using this formula =IF(ISBLANK(D6),"",D6/C6) and when i press enter is comes up as #VALUE! when it should come out as a percentage 

3 Replies


Does D6 contain a formula? If so, try




You may also want to check for C6 being 0:




Either C6 or D6 contains text and not a number.
Check with ISNUMBER() or ISTEXT().
This is partially work but when I press enter the 0.0% pops up for a second then goes away right way