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.
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,
Serdet I assume you refer to the errors in columns P, Q and R. Fixed the formulae in these columns and copied the headers in P2:R2 to C1:E1 in the Tonnage sheet. These headers must be exactly the same, otherwise the MATCH will not work.
If you want to get rid of the remaning #N/A's (due to the fact that there are no values for Pressure and Plume size), wrap the entire formula in =IFERROR(INDEX(...........),"").
- Thank you very much. I was assuming the C$2 referred to the column located in the separate 'Tonnage' tab.