|
|
#1
01-05-2017, 03:23 AM
|
|||
|
|||
Help to create this formula:
Hello guys nice to join this forum
 Happy New Year to all.Now basically i need to create 2 simple formula (i think so).. The first one is when i put a number (X) i want to return the min and max value from a table witch it fits in ( A and B) please check the screenshots atached. The second formula after achieving the first one i want for the min value to return the near cell value (factor 2)... Please i remind you that i want to do all above things as an array .. i dont know if you understand what i want... Thnak you in advace! 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How to create mileage formula
|
maxliv | Excel | 4 | 08-15-2016 08:13 AM |
| Create a formula to count all occurances of HH but multiply by 0.5 first | stupidgirl | Excel | 6 | 06-14-2016 03:50 PM |
|
Create formula for entire column
|
tdodson | Excel | 2 | 10-27-2015 09:38 PM |
|
How to create a formula using the IF in a time sheet.
|
spaul | Excel | 3 | 10-28-2013 07:19 PM |
| Please help me create this formula... | doublejoy | Excel | 1 | 08-22-2009 03:04 AM |
Windows 7 64bit 
Office 2007
Threaded Mode