I have a reasonably complicated spreadsheet which includes whatif functions in certain areas. In one particular "if" function, the formula includes a divisible calculation that may under certain circumstances become "0" but in other circumstances become a number greater than "0". In other words the "if" function needs this formula. How do I have excel ignore the "div/0" error when this condition exists. Here is the formula:
=IF(DL23*(AJ23+AK23)/SUM(AJ23:BI23)<DB23,DL23*(AJ23+AK23)/SUM(AJ23:BI23),DB23)
DL23 will always have a number great than "0"
AJ23 & AK23 may not have a number great than "0"
SUM(AJ23:BI23) may not have a number great than "0"
DB23 may not have a number great than "0"
Your help would be greatly appreciated
Garry
This message was edited by pilot48 on 2002-05-11 14:42
=IF(DL23*(AJ23+AK23)/SUM(AJ23:BI23)<DB23,DL23*(AJ23+AK23)/SUM(AJ23:BI23),DB23)
DL23 will always have a number great than "0"
AJ23 & AK23 may not have a number great than "0"
SUM(AJ23:BI23) may not have a number great than "0"
DB23 may not have a number great than "0"
Your help would be greatly appreciated
Garry
This message was edited by pilot48 on 2002-05-11 14:42