Google Spreadsheet Post #1542
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-21-2014
post by Mike Ladouceur (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/OFWcRkp2IbI)
Getting the last item in a list
I'd like to have a cell get the last item in a list. They're all dollar values and if it's $0.00 it seems it sets the cell to $0.
Example:
H3=$1000.00
H4=$1200.00
H5=$1100.00
H6=$0.00
then F1=$1100.00
----------------------------------------------------------------------------------------------------------------------------------------------------
following is the solution to a bit more generalized problem
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Feb-21-2014
post by Mike Ladouceur (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/OFWcRkp2IbI)
Getting the last item in a list
I'd like to have a cell get the last item in a list. They're all dollar values and if it's $0.00 it seems it sets the cell to $0.
Example:
H3=$1000.00
H4=$1200.00
H5=$1100.00
H6=$0.00
then F1=$1100.00
----------------------------------------------------------------------------------------------------------------------------------------------------
following is the solution to a bit more generalized problem
No comments:
Post a Comment