Here is an example what I thought in my yesterday's post.

Enter data from all your 3 normal power tables into table on NormalPower sheet (i filled it only enough to use your example data) - for all frequencies from A through D.

On sheet EBI200, edit the value returned when data were out of range, i.e. the formula returns 0. Currently the empty string is returned when this is the case.

Attached Files

AnExample.xlsx (14.1 KB, 8 views)