Miltiple if and roundup question

brazill23

New Member
Joined
Dec 18, 2018
Messages
11
Hi All,

I have formula with calculating order and after round in up to nearest 100. I have issue with one additional argument - if result is bigger then 0 but smaller then 500 round up to 500. As my minimum order is 500 after this its just 500+100 ect... any suggestions ? :confused:

=IF(AD107="Order",ROUNDUP(IF((SUM(OFFSET(O104,0,0,1,AB106))-O105)<0,0,(SUM(OFFSET(O104,0,0,1,AB106))-O105)),-2),0)

Thank you in advance :):confused:
 

Some videos you may like

Excel Facts

What does custom number format of ;;; mean?
Three semi-colons will hide the value in the cell. Although most people use white font instead.

AlanY

Well-known Member
Joined
Oct 30, 2014
Messages
3,981
Office Version
365, 2019, 2016
Platform
Windows
just add a max() like this

=max(500,[your formula here])
 

Watch MrExcel Video

Forum statistics

Threads
1,102,508
Messages
5,487,302
Members
407,590
Latest member
Grobler

This Week's Hot Topics

Top