I have the following formula in cell BT27:
=VLOOKUP(BV27,'Rates NEW'!F:H,3,FALSE)+VLOOKUP(BO27,'[Timesheet Input DO NOT MOVE OR RENAME WORKING TEST.xlsm]Pay Elements'!$B:$H,7,FALSE)
The result in this example in cell CR4 is 35 But I want it to also look at cell BD4 and if cell BD4 contains “CS” I want the maximum value in cell CR4 to be 30.
How do I do this please?
Solved by X. U. in 21 mins