IF Function

[Hi1]

I have a list of numbers and I need the IF function to do the following -

Put stars (i.e. ***) into the cells adjacent if the function changes sign (ie, -ve or +ve) over the corresponding intervals (e.g. A1 to A2, A2 to A3, etc.).

“IF” functions that put the upper and lower limits the containing cells when the changes have been detected

[alansidman]

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[Hi1]

For example in the root column I need it to show a *** or any sort of marker at the point where the sign changed, then also show the lower and upper limits in that row so 0.0280 lower and 0.048 upper

[bryan0]

Put this formula in cell C7 and drag down:
=IF(OR(AND(B7>0,B6<0),AND(B7<0,B6>0)),"***","")

It will make the first cell of a different sign ***. Is that what you're looking for?