I have a formula that is pulling data from other tabs and it works fine. I want to be able to round the result.
This is the formula that I am using to pull data from other tabs:
=((INDEX(SCHRS!B:B,(MATCH($A:$A,SCHRS!$A:$A,0)))))/$AF2
This is what I am trying to do by adding to the end of the formula:
If the result value is greater than 1.00 then round down to 1.00.
If the result value is less than 1.00 it should remain what it is and not change.
I have tried using ROUND and IF formulas but can't find anything to add to the end of the formula to make this work. I would appreciate any help you can provide please. Thank you.
Bookmarks