| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need help for a formula
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calculation on conditions.
Do you mean? =IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"") copied across. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115448 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calculation on conditions.
Yes but I need it to continue going thru E2
"NBVC" wrote: Do you mean? =IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"") copied across. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115448 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help for a formula
I hit ok to soon. When I copy the formula across to include thru E, I get
back #VALUE! "Dot" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calculation on conditions.
Does F2 contain text? Try: =IF(ISTEXT(B2),"",IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"")) copied across. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115448 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calculation on conditions.
No, F2 is blank.
If the answer is yes in B2, then C2 thru E2 will be blank as well. "NBVC" wrote: Does F2 contain text? Try: =IF(ISTEXT(B2),"",IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"")) copied across. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115448 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calculation on conditions.
Maybe you can post the sample raw data and expected results (and describe how the expected results came to be) -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115448 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calculation on conditions.
Hi,
try entering in cell A3 =IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"") and in cell B3 =IF(A3="","",IF(AND((B2-$A$1)/$A$1<=0.00025,B2-C2<=0.0005),C2,"")) copy this formula to your right "Dot" wrote: No, F2 is blank. If the answer is yes in B2, then C2 thru E2 will be blank as well. "NBVC" wrote: Does F2 contain text? Try: =IF(ISTEXT(B2),"",IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"")) copied across. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115448 |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Formula to calculation on conditions.
The formula is great, that's what I had but I need it to keep going thru E2
but haven't been successful to get it all into one cell and one formula. (i.e., if not A2 then B2, if not then C2, if not then D2, if not then E2, then stop). "Eduardo" wrote: Hi, try entering in cell A3 =IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"") and in cell B3 =IF(A3="","",IF(AND((B2-$A$1)/$A$1<=0.00025,B2-C2<=0.0005),C2,"")) copy this formula to your right "Dot" wrote: No, F2 is blank. If the answer is yes in B2, then C2 thru E2 will be blank as well. "NBVC" wrote: Does F2 contain text? Try: =IF(ISTEXT(B2),"",IF(AND((A2-$A$1)/$A$1<=0.00025,A2-B2<=0.0005),B2,"")) copied across. -- NBVC Where there is a will there are many ways. 'The Code Cage' (http;//www.thecodecage.com) ------------------------------------------------------------------------ NBVC's Profile: http://www.thecodecage.com/forumz/member.php?userid=74 View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=115448 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
