It may help if you describe that more in detail. Date-based functions are usually very specific to individual criteria.unless the name and week are the correct ones
Could you post an example worksheet?
It may help if you describe that more in detail. Date-based functions are usually very specific to individual criteria.unless the name and week are the correct ones
Could you post an example worksheet?
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
My issue here is this,
If I select a valid name and race, and I enter values for the laps into the calculator, the formula will enter whatever value is in the Average field. However, as soon as I change the value in either the Name drop-down or the Race drop-down, I will get a FALSE value in the cell that I was previously making changes to.
So how would I be able to set this up so that the values in the chart stay the same unless the 2 values from the drop-down menus meet the exact criteria to have a change happen.
Thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks