LinkBack URL
About LinkBacks
Need a formula to compare then have appear the larger value between two cells. General logic is IF cell F17>cell F21 then show the value in cell F17, IF F21>F17 then show value in cell F21. Thanks for any suggestions and assistance.
compare & show
Need a formula to compare then have appear the larger value between two cells. General logic is IF cell F17>cell F21 then show the value in cell F17, IF F21>F17 then show value in cell F21. Thanks for any suggestions and assistance.
=MAX(F17,F21) Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Response from ChemistB should do the trick, but you could also use something like:
=IF(F17>F21,F17,F21)
Thanks, your 2¢ helped me lot$.
Last edited by pumpkin; 11-13-2009 at 12:18 PM. Reason: solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks