Lamda Max on Google Sheets

Question

I am plotting a Abs vs Wavelength graph and am trying to find lamda max. I have already graphed it on google sheets but cannot figure out how to find the value.

Answer 1

In order to have graphed the abs in sheets, you needed to have entered the abs value against the wavelengths in a table format. You can manually obtain the values from the table. Lambda Max will just be the wavelength at which the biggest abs value occurs.

or you can also use the function MAX in google sheets. You would enter the following into a new cell

=MAX

Then select the range of cells that have the abs readings.

Then it will look something like what's shown below. (This has the range of cells A1 to A10)

=MAX(A1:A10)

Press enter after selecting your ABS readings and it will give you the biggest ABS value.