I have a set of multiple formulas that generate certain values. I need to set limit to the values generated. For instance, if the value is less than 200, I need the actual value which is less than 200, and if the value is greater than or equal to 200, I need 200 only. the formula is copied for reference. Someone plz help
=IF(AND(O3="W",E3>='Workings Model'!$O$2,Trip!E3<'Workings Model'!$P$2),Trip!F3*'Workings Model'!$Q$2%,"")&IF(AND(Trip!O3="W",Trip!E3>='Workings Model'!$O$3,Trip!E3<'Workings Model'!$P$3),Trip!F3*'Workings Model'!$Q$3%,"")&IF(AND(Trip!O3="W",Trip!E3>='Workings Model'!$O$4,Trip!E3<'Workings Model'!$P$4),Trip!F3*'Workings Model'!$Q$4%,"")&IF(AND(Trip!O3="W",Trip!E3>='Workings Model'!$O$5,Trip!E3<'Workings Model'!$P$5),Trip!F3*'Workings Model'!$Q$5%,"")&IF(AND(O3="W",Trip!E3>='Workings Model'!$O$6,Trip!E3<'Workings Model'!$P$6),Trip!F3*'Workings Model'!$Q$6%,"")&IF(AND(Trip!O3="E",Trip!E3>='Workings Model'!$O$7,Trip!E3<'Workings Model'!$P$7),Trip!F3*'Workings Model'!$Q$7%,"")&IF(AND(Trip!O3="E",Trip!E3>='Workings Model'!$O$8,Trip!E3<'Workings Model'!$P$8),Trip!F3*'Workings Model'!$Q$8%,"")&IF(AND(Trip!O3="E",Trip!E3>='Workings Model'!$O$9,Trip!E3<'Workings Model'!P10),Trip!F3*'Workings Model'!$Q$9%,"")&IF(AND(O3="E",E3>='Workings Model'!$O$10,Trip!E3<'Workings Model'!$P$10),Trip!F3*'Workings Model'!$Q$10%,"")&IF(AND(Trip!O3="E",Trip!E3>='Workings Model'!$O$11,Trip!E3<'Workings Model'!$P$11),Trip!F3*'Workings Model'!$Q$11%,"")&IF(AND(Trip!O3="R"),0,"")
Bookmarks