IF function returning a value to several cells in a row - Microsoft Community
i trying use if function check date when employee starts work (for financial model) , if dates match, monthly salary returned in each cell remaining months of year. table below shows desired outcome
| a |
b | c | d | e | f | g | h | i | j | k | l | m |
| 1 | ||||||||||||
| 2 | start | annual | monthly | jul-17 | aug-17 | sep-17 | oct-17 | nov-17 | dec-17 | jan-18 | ||
| 3 | ||||||||||||
| 4 | salary1 | aug-17 | 60,000 | 5,000 | 0 | 5000 | 5000 | 5000 | 5000 | 5000 | 5000 | |
| 5 | salary2 | oct-17 | 60,000 | 5,000 | 5000 | 5000 | 5000 | 5000 | ||||
| 6 | salary3 | jan-18 | 60,000 | 5,000 | 5000 |
i tried formula salary1 starting in aug 17
=if(h2=c3),e4,0 - works , returns 5000 in h4. want 5000 returned in i4, j4, k4, l4 , m4 well. there formula achieve this, perhaps replacing e4 {e4:m4} - thanks
@tonytaccone
in g4: =if(g$2 >= $c4, $e4, 0)
then copy right , down necessary
Office / Excel / Windows 8 / Office 2010
Comments
Post a Comment