[Solved] Carry over the greater value from three columns

Discuss the spreadsheet application

[Solved] Carry over the greater value from three columns

Postby egfreeze » Wed Jul 17, 2019 4:45 pm

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.
Last edited by Hagar Delest on Wed Jul 17, 2019 10:29 pm, edited 1 time in total.
Reason: tagged solved
OpenOffice 4.1.6 on Windows 10
egfreeze
 
Posts: 4
Joined: Mon Jul 01, 2019 4:47 pm

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

Postby Villeroy » Wed Jul 17, 2019 4:46 pm

=MAX(H2:J2)
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04, no OpenOffice, LibreOffice 6.x
User avatar
Villeroy
Volunteer
 
Posts: 27105
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

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

Postby egfreeze » Wed Jul 17, 2019 4:47 pm

I feel stupid, thanks.
OpenOffice 4.1.6 on Windows 10
egfreeze
 
Posts: 4
Joined: Mon Jul 01, 2019 4:47 pm


Return to Calc

Who is online

Users browsing this forum: No registered users and 38 guests