LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
dot dot is offline
external usenet poster
 
Posts: 29
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 11:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"