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
|