Need a Forumula

[vmohan1978]

Dear All,

I need a formula


D E F G H I


23 2 1 11.00 0 0


In I i needa formula if ( G23=0, h23=0, result is Product(d23:f23) and IF(F23=0,D23*E23,IF(G23=0,ROUND(D23*E23*F23*H23,2),IF(H23=0,ROUND(D23*E23*F23*G23,2),ROUND(D23*E23*F23*G23*H23,2))))


Please do the needful.

 

[Faseeh]

Hi vmohan1978


Please checkout this formula:


IF(AND(G23=0,H23=0),ROUND(D23*F23,2),IF(F23=0,ROUND(D23*E23,2),IF(G23=0,ROUND(D23*E23*F23*H23,2),IF(H23=0,ROUND(D23*E23*F23*G23,2),IF(I23=0,ROUND(D23*E23*F23*G23*H23,2),)))))


You have't mentioned result for I23=0, I assumed it is the last part of formula is your post i.e. if(i23=0,ROUND(D23*E23*F23*G23*H23,2))?? Is that correct?


Hope it works.


Regards,

Faseeh

 

[vmohan1978]

Dear Faseeh,

Thank you very much it worked perfectly . It saved my lot of time.

 

[Faseeh]

You are welcome any time.


Faseeh