Forum Discussion
IF Function
not sure I will be able to explain this clearly.
I work in pensions, and i'm creating a spreadsheet that will calculate a pension, part of which needs to be revalued. however, depending on what year the pension commences, it revalues at a different rate.
an initial spreadsheet is filled in and from there, based on the year of commencement, 1 or 2 elements are revalued annually at differing rates.
i have extracted the year from the first tab using = (Year "name"d9) etc
i added a third tab, which includes two revaluations for each of the two elements that may need revaluing. one that starts in 2013, and one that starts in 2014.
this revalues the pensions by the annual PI and gives a resultant figure for the current value of that particular element.
but what i want to do now, which I feel may use the IF function but may not, is somehow get the cell to recognise that the year is 2013 or 2014 based on the above year function i used, and then use the figure which applies to that year. if that makes sense? ,
can you use if function and tell it to use a certain cells value
in my head it would work like this eg:
=IF C8 = 2013 use value in G10, if C8 doesnt equal 2013 then use value in H10
whether thats possible is another matter.