| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Need help with IF statement (function)
I have 1,2,3,4,5,0 for cell A1, B1, C1, D1, E1, and F1 respectively. I want a function that would give me result of for example D2 with 25% and E2 with 50%. This means that when the next number is zero, the function would provide a result for the last two cells with numbers (other than zero) prior to that zero. Please see attached picture.
Last edited by managingcrap : November 8th 13 at 01:17 PM |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Need help with IF statement (function)
Hi,
Am Fri, 8 Nov 2013 13:13:19 +0000 schrieb managingcrap: I have 1,2,3,4,5,0 for cell A1, B1, C1, D1, E1, and F1 respectively. I want a function that would give me result of for example D2 with 25% and E2 with 50%. This means that when the next number is zero, the function would provide a result for the last two cells with numbers (other than zero) prior to that zero. Please see attached picture. in A2 try: =IF(A1=0,"",IF(MATCH(0,B1:$F$1,0)=1,0.5,IF(MATCH(0 ,B1:$F$1,0)=2,0.25,""))) und drag the formula to E2 Regards Claus B. -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can function be used within SQL statement? | Excel Programming | |||
| Function or If statement help | Excel Worksheet Functions | |||
| IF function returns function statement rather than result | Excel Worksheet Functions | |||
| Function IF statement | Excel Worksheet Functions | |||
| MID STATEMENT vs MID FUNCTION | Excel Programming | |||
Linear Mode
