Forum Discussion
Multiple IF formula calucation
Serdet As indicated in my previous post, I used some named ranges (dataset2, headers, pressure and plume size). This makes the formula easier to write, read and maintain. Added them to your sheet. See attached.
Thanks for getting back to me. I have tried to implement the formular used in your spreadsheet but are having problems due to my 'dataset2' being located on a different 'Tonnage' tab.
Please see the attached.
Many thanks,
Elliot
Serdet Cutting a few corners here, because it can be done better. just don't have the time right now, but the attached file contains working formulae. Note that I also added the named ranges required.
Hi Riny_van_Eekelen,
Thank you for sending that over. I have copied your formula into my spreadsheet but are receiving a #NAME? error.
I have double-checked the two but cannot spot any differences. Any ideas on where I might be going wrong?
Many thanks,
Elliot
Serdet As indicated in my previous post, I used some named ranges (dataset2, headers, pressure and plume size). This makes the formula easier to write, read and maintain. Added them to your sheet. See attached.
Hi Riny_van_Eekelen ,
Sorry to bother you again. I have implemented the formula into the attached excel spreadsheet and are revieving errors.
I have tried renaming the cell selections but have had no luck. Any tips?
Many thanks,
As a comment, to be safe I'd use separator for concatenation to avoid situation when =1&23 and =12&3 return the same.
