Forum Discussion
Angelo_Crespo
Apr 08, 2022Copper Contributor
Excel
I am quoting a wire job and usually, wire is priced per 1000/M.
Example:
5000' - $6523.00m = $32,625
My quandary is pricing an odd number, such as, 5700'
How is this expressed in Excel???
1 Reply
- Riny_van_EekelenPlatinum Contributor
Angelo_Crespo Perhaps like this?
It will round up each length to the next thousand and multiply that number by the price per thousand.