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

@MiaMcHnenry465 

Does D6 contain a formula? If so, try

 

=IF(D6="","",D6/C6)

 

You may also want to check for C6 being 0:

 

=IF(OR(D6="",C6=0),"",D6/C6)

Hi

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