Using "" in the same formula
Posted by Christy on February 13, 2002 10:34 PM
I am trying to get a formula to perform the following:
"If b5 is less than 43 then /1; if b5 is greater than 43 but less than 85 then /2. This goes on in multiples of 42 but if I get the first two, I can add the rest(she says with the utmost confidence). The same cell which contains this formula (B7) is where I'd like the outcome to show, if possible. Any help would be awesome - I've now pulled ALL my hair out!!
Thank you so much!