round if

Hi, I'm very new to Excel and need some help (with a maybe very basic function). I need to create a system that choose between two parameters to round up or down the number depending on a condition. This is for scoring students with a decimal system, so I need to round the final score. What I...

<colgroup><col><col span="2"></colgroup><tbody> Barcode Price Result 110022002095 43.7535 45 2200000000019 78.75 80 2200000000026 105 105 2200000000033 105 105 2200000000040 105 105 2200000000057 105 105 2200000000064 175.0035 175 2200000000071 52.5 55 2200000000095 15.75 16...

Greetings! I've boldened the portion of my formula in question, below. The columns [Unit Value] and [Mean] primarily contain numbers with 8 decimal places. My First Formula works well - it basically looks for each instant where the data in column Unit Value equals or exceeds the data in...