Page 1 of 1

[Solved] Carry over the greater value from three columns

PostPosted: Wed Jul 17, 2019 4:45 pm
by egfreeze
I have three columns with item prices in them. I'm trying to get the highest price of the three column to populate another column. For example, H2-J2 have prices in them. I'm trying to have the greatest of those prices to populate G2. I've been trying to do it with an IF() formula but I'm not having luck with that. What's the easiest way to accomplish this? Thanks.

Re: Trying to carry over the greater value from three column

PostPosted: Wed Jul 17, 2019 4:46 pm
by Villeroy
=MAX(H2:J2)

Re: Trying to carry over the greater value from three column

PostPosted: Wed Jul 17, 2019 4:47 pm
by egfreeze
I feel stupid, thanks.