Help with If greater than

[wxman15]

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.

[TMS]

Try,

Please Login or Register  to view this content.

[mehmetcik]

Formula for D5 =MAX(G6:H6)+D5

[wxman15]

Formula for D5 =MAX(G6:H6)+D5

This formula is what I was looking for. Thanks for the help.

[TMS]

I thought you needed to take into account the "1/3 headwind, max 15 kt" ???

Hence:

Please Login or Register  to view this content.

[wxman15]

I thought you needed to take into account the "1/3 headwind, max 15 kt" ???

Hence:

Please Login or Register  to view this content.

Your formula works as well in which I decided to use that one. Anything higher than the max 15kt rule would suggest that I'm flying into a headwind of more than 40 knots, like flying into a tornado or hurricane, something that pilots will never do in real life with passengers. Honestly, never saw airlines land into a headwind more than 30 knots. I guess I needed more of a "take the max value based on these criteria" formula rather than an "If greater than" formula.

[TMS]

Simply a case of taking into account the factors on the spreadsheet. If you don't need the added detail/complexity, don't bother with it.

In simple terms, you have two values and you want to use the biggest one. So, use MAX 🙂