IF and ROUNDUP in same formula

I am trying to roundup the result in CELL P8, I already have this formula in there – 

=IF(C8=”VHW-HWPS-B8″,F8/8,IF(C8=”VHW-HWPS-B8-LL”,F8/8,IF(C8=”VHW-HWPS-B4″,F8/4,IF(C8=”VHW-HWPS-B4-LL”,F8/4,IF(C8=”VLS-1P-B”,F8,IF(C8=”VLS-1P-BC”,F8,IF(C8=”VHW-HWPS-B”,F8,IF(C8=”VHW”,F8))))))))

 

How do i add roundup to this. The result in there now is 5.25 and I want to make it 6.

 

Thanks Tony

By: Tony Lannon

Leave a Reply

Your email address will not be published. Required fields are marked *