I am looking up values from battery datasheets based on a calculation of C rating.
However since not all battery manufacturers publish the same C rates I am wanting to get the next lowest value.
Example shows:
Input fields
Battery model (dropdown list based on table)
Days of Automony
Max Battery DoD values
Formula's
Requested C/Rate returns the desired C Rate value to lookup from Table (datasheets input)
Returned Ah I would like to return the Ah capacity of battery at desired Rate, (or next lowest)
But I don't know what formula to use for column reference (If one can be used)
In the example I would like the Returned Ah formula to provide the next lowest C rating Ah, In this image it would be C/20 Rate of 415.
I thought about naming the table columns, i.e 8,10,12,20,24,48,100
But I still can't figure out how to check if blank, move left until not blank