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
You can change this formula:
=(1-((AI138+AK138)/AV138))*AV138/P138*1000 to this: =IF(P138=0,0,(1-(AI138+AK138)/AV138)*AV138/P138*1000) to avoid the #DIV/0 error. Then the other formula you want becomes: =IF(P138*AC138/1000,P138*AC138,SUM(AO138:AT138)) Hope this helps. Pete 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
=if((p138*ac138)/1000,p138*ac138,sum(ao138:at138))
Dave -- Brevity is the soul of wit. "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
IF Function
Pete_UK wrote: You can change this formula: =(1-((AI138+AK138)/AV138))*AV138/P138*1000 to this: =IF(P138=0,0,(1-(AI138+AK138)/AV138)*AV138/P138*1000) to avoid the #DIV/0 error. Then the other formula you want becomes: =IF(P138*AC138/1000,P138*AC138,SUM(AO138:AT138)) Hope this helps. Pete Worked perfectly! Thank you to all who replied. 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 |