Forum Discussion
Solved
Multiple If statements
What I am trying to do and it is WAY outside my skill set. I can't even begin to type a formula for it. If B4="kgs" then A8 returns a value of .23 If B4="lbs" then A8 returns a value of .5 ...
Depending on how many variable conditions are involved, this might also call for a two dimensional array, accessed by INDEX and MATCH.
As Patrick2788 has already said, you could help us help you by articulating all of the conditions and consequences in as orderly fashion as possible (some tabular form would be ideal) and even better, accompany that by posting a copy of the workbook on OneDrive or GoogleDrive with a link here that grants access.
D8 cannot contain a text such as "Word 1" and a number such as 2 at the same time...