3 condition IF statement help needed

[Alex D]

Need help with formula that will go in column B please...

IF column A is equal to or greater than 370, then I want the result to be Column A x 0.90
IF column A is equal to or less than 336, then I want the result to be the same value as in column A
IF column A is anything else other than those 2 conditions, then I want Column A to be 336

A	B
150
378
345

 

[Michael M]

TRy

=IF(A2<=336,A2,IF(A2<370,336,A2*0.9))

 

[Fluff]

Another option

=IF(A2>=370,A2*0.9,MIN(A2,336))