I am requesting help to use an if function to do the following:
if cells C3 and C8 are both empty, leave the cell empty, otherwise divide C8 by C3.
I entered this and it resulted in Err:509 =IF(C3:C8)="";"";(C8/C3)
Another problem is when I enter the above formula, it is changed to =IF(C3:C8)="","",(C8/C3)
Notice that the semicolons are replaced with commas and still has Err:509.
Your help is greatly appreciated.