Excel 2007 : If and or If or formula doubt

**lizsantiago07** · 06-07-2012, 11:23 AM

Hi everyone and first thks everyone for the help you give us... i have a problem with a formula, i am trying to do the following

=IF(and(F10="","",f6="","",(F10/F4)) but is not working

if the cells f10 and f6 are blank return blank if not then dive them but i am getting an error. can you help me?

**amotto11** · 06-07-2012, 11:27 AM

try

=If(And(F10="",F6=""),"",(F10/F6))

**lizsantiago07** · 06-07-2012, 11:33 AM

nope not working

**amotto11** · 06-07-2012, 11:34 AM

what is the error?? can you post your workbook.

**lizsantiago07** · 06-07-2012, 11:39 AM

the error is that when i delete f4 all the other formular write ###### and since this is a rollbook i am making i want the formulas to do nothing if some cells are blank until i write the points.
so this is what i need : if f4 and f10 are blank then in f11 be blank if i write the points then in f11 divide f10/f4