Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have tried everything I know to do and can't get this formula to work.
A1 1.0161 A2 B2 C2 D2 E2 1.0148 1.0163 1.0155 1.0164 1.0160 The above cell may or may not all be filled out, but if they are, I need a formula that returns answer in another cell. I need the formula to first take each cell A2 thru E2 to do: A2-A1/A1 then Return in cell A3 if the A2-A1/A1 formula is <=.00025 and A2-B2 is <=0.0005 if, so, then B2 and then repeat on each cell A2-E2 - I can only get the formula to return B2 and can't get it to take a look at the other cells |