Hello,
Need help if figuring out how to write a IF Greater than formula. I’ve attached my test file. The idea is to determine which value to use in Cell D6 based on the rule from Cells G5:H6.
In Cell G4, the rule is that I have to make correction for Cell D6 based on the value inputted in Cells G6 and H6 and take whichever value is higher, add it to the value in Cell D5 to get my answer in Cell D6. So for example, let’s say the headwind is at 18 kt, then I take 1/3 of that (18/3=6). Since 6kt is greater than the 5kt correction (Cell G6), then I would want the formula in Cell D6 to take that value from Cell H6 and/or take the opposite if Cell G6 was greater than Cell H6. Thank you.
Bookmarks