Thread
:
IF formula question
View Single Post
#
2
Sandy Mann
Posts: n/a
Assuming that you want part 100's rounded up to the next 100,
=IF(A1="","",MAX(2,CEILING(A1,100)/100))
--
HTH
Sandy
Replace@mailinator with @tiscali.co.uk
"Barb1" wrote in message
...
I need a formula for this situation.
For folding sheets of paper, the charge is 1.00 per 100, with a 2.00
minimum
charge.
Thanks,
Barb
Reply With Quote