Jan 17 2022 12:53 PM
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
Jan 17 2022 01:14 PM
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)
Jan 17 2022 01:15 PM
Jan 17 2022 01:24 PM