lotus formula to excel formula conversion

[Traymond]

I have a huge lotus workbook that i have been working on converting to excel. Just so nobody thinks i am trying to get someone else to do my work , i have about 30 hrs of time in it so far and have had success converting about 95% of the formulas that needed correcting ( some bigger than these two i need help with) . for some reason i can't get the syntax right on these two formulas no matter how much i work at it. could somebody offer any assistance . I have attached the file that i am working on. i colored the two cells with the formulas i need help with (red). also if you look at Cell M10 (colored orange) you can see where i have been working on the formula and have made some progress.

In the cells that need the formulas converted :
the values that should show up if the formulas are correct.

F22 = 0
F25 = 29.0

Thanks so much ,

[NBVC]

Try this in F22:

=IF(C10=0,0,IF(OR($C$10+$E$10>F$19,$C$11+$E$11>F$20),"n/a",IF(ISERR((ROUNDDOWN(F$19/($C$10+$E$10),0.1)*ROUNDDOWN(F$20/($C$11+$E$11),0.1))*$C$12),0,(ROUNDDOWN(F$19/($C$10+$E$10),0.1)*ROUNDDOWN(F$20/($C$11+'Part Data'!$E11),0.1))*$C$12)))

and this in F25:

=IF(F24=F22,ROUNDDOWN(F19/($C$10+$E$10)*C12,0.1),IF(F24=F23,ROUNDDOWN(F20/($C$10+$E$10)*C12,0.1),0))

each copied down 1 row and across.

You'll need to review the logic... I don't get 29 for F25.

[Traymond]

let me do some checking on the logic for f25 to see what is going on there. could you look at one other thing. see how the ##### symbols show up in f21:m21. they should display 100%.

I21 does but all the others just display ######

[NBVC]

Just widen the columns...

[Traymond]

DUHHH!!!! i worry bout myself sometimes. the f22 formula is perfect. I still need to see what is going on with f25. i can look at your formula and should be able to go from there . thanks for the help