Forum Discussion
Solved
Multiple IF formula calucation
Hi All, I have a 2 datasets similar to the below. Data Set 1 Pressure Plume Size Flowrate (kg/hr) Flowrate (T/hr) Save Value (k$/yr) 3 0.5 3 1 ...
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.
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,