Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
Hi:
I need help with the following function: if sum(P138*AC138/100)0 then I want that sum (P138*AC138) otherwise sum(AO138:AT138) I don't know if this makes a difference; however, the calc in AC138 is =(1-((AI138+AK138)/AV138))*AV138/P138*1000 which returns #DIV/0! because P is entered as zero which is correct because that field is not relevant to that account. If this is not clear I can try to provide more detail. Thanks cheetah |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
=IF(P138*AC138/1000,P138*AC138,SUM(AO138:AT138))
If AC138 look at using the following which sets AC138=0 if P138 is 0. =if(P138=0,0,(1-((AI138+AK138)/AV138))*AV138/P138*1000) HTH "cheetah" wrote: Hi: I need help with the following function: if sum(P138*AC138/100)0 then I want that sum (P138*AC138) otherwise sum(AO138:AT138) I don't know if this makes a difference; however, the calc in AC138 is =(1-((AI138+AK138)/AV138))*AV138/P138*1000 which returns #DIV/0! because P is entered as zero which is correct because that field is not relevant to that account. If this is not clear I can try to provide more detail. Thanks cheetah |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need some comments on my Utility_Move class module. | Excel Worksheet Functions | |||
Creating a Custom Excel Function to Calculate Gini Coefficients | Excel Worksheet Functions | |||
Date & Time | New Users to Excel | |||
Conversion | Excel Worksheet Functions | |||
HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions |