G Gotworked New Member Dec 18, 2020 #1 =IF((AND(F10=0,G10=0)=TRUE),0,((A10/(G10*F10))*(((F10-1)*(B10+0.24)*(C10))+(1*(B10+0.24)*(C10+(H10/2)+0)))))
=IF((AND(F10=0,G10=0)=TRUE),0,((A10/(G10*F10))*(((F10-1)*(B10+0.24)*(C10))+(1*(B10+0.24)*(C10+(H10/2)+0)))))
Hui Excel Ninja Staff member Dec 18, 2020 #2 What unit are you converting to what unit ? Can you please post a sample file?
