I am having trouble creating a formula that works correctly. Say I have 5 columns set up for day 1 through day 5. In the row 1 have currency rates for all but day 4.
I am trying to figure out a formula that will look at the data and let me know if any of my data points is above a tolerance level. But I need to exclude any day I do not have a value for like day 4. Any suggestions on how I may create this?
I am trying to figure out a formula that will look at the data and let me know if any of my data points is above a tolerance level. But I need to exclude any day I do not have a value for like day 4. Any suggestions on how I may create this?