I'm currently working on a spreadsheet for my Computer Science Lab, and I've been stuck on a few formulas for quite a while. Our book, for the class, does not help us and even Excel's formula for dummies-esque set-up I can not seem to figure out what the hell I'm supposed to do, despite how easy it seems like it should be.
What I'm trying to do right now is:
If the Code (column 'H' in my spreadsheet) is "G" then return the current Volume (column 'G' in my spreadhseet). Else, convert the Volume (again, column 'G') from liters to gallons - using the L_PER_GAL cell already created.
I have no idea if this makes sense, and if it doesn't that just proves how completely confused I am by what should be a damn simple function to make.
Anyone have any suggestions or tips or helpful advice? I don't think I've ever asked for help on any of my work on here...but I really just can't figure this out at the moment.
What I'm trying to do right now is:
If the Code (column 'H' in my spreadsheet) is "G" then return the current Volume (column 'G' in my spreadhseet). Else, convert the Volume (again, column 'G') from liters to gallons - using the L_PER_GAL cell already created.
I have no idea if this makes sense, and if it doesn't that just proves how completely confused I am by what should be a damn simple function to make.
Anyone have any suggestions or tips or helpful advice? I don't think I've ever asked for help on any of my work on here...but I really just can't figure this out at the moment.
Comment