Help with If function
HI, I am trying to export relationships into a new database. I have to add the account number for each relationship type and there are many relationship types. There are more empty relationship types with no data than with actual data. I want it to say if the data in the relationship type (Company Relationships) is not empty then the relation account number should be the same. Can someone help me figure out why i have made this so difficult? I think I have it backwards but am not sure how to say if B2 is not blank or not empty. Thanks so much for your help. Mary Ellen =IF(B2<>"",C2=A2) Indiv Account Number Company Relationships Relationship Account Number 336 Minuteman Press FALSE 76 Kona Ice Midtown 494 enewton design 2574 2773
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.
Help with IF function. Please help!
I know this should be easy but we had no help at all with this. Here are the instructions for this step: "Insert an IF function in cell E5 to calculate the total due. If the student has chosen to personalize the ring, there is an additional charge of 5% located in cell B21 that must be applied; if not, the student only pays the base price. Use appropriate relative and absolute cell references." Thanks
