Columns A, B, C have the data. If Column C has data it will override columns A&B. If columns A & B have data but no data in column C default to column B, no matter what the value is in column A. No data in Column B and Column C defualts to Column A. The if statement formula would be in column D.
Hi Jess, It's possible. Maybe I'm not being clear in my words. Take a look at my spreadsheet. I have a formula issue. Sorry typo in the spreadsheet. The last row should be 10,000 not 50,000
Yes these are my conditions above. As you can see in my attachment my formula is off just a little for these conditions.
I'm sorry but I can view these files? For some reason this Wikisend.com won't allow to view the spreadsheet. Can you attach excel spreadsheet? In this email thread?
I can now view the spreadsheet however my data has been brought into from an data source. The excel formula will not work because the formula does not view data as a number. How do I convert into number?
This formula =IF(ISBLANK(C2),IF(ISBLANK(B2),A2,B2),C2) needs excludes zero(s). I was thinking it was a formatting issue above but it's not. Again, I was not clear in my example above because the data does include zero(s). In my organal formula that's why I was using greater than or less than. Can this formula be adjusted to exclude zeros?
This revised formula works great. =IF(OR(ISBLANK(C2),C2=0),IF(OR(ISBLANK(B2),B2=0),A2,B2),C2). Thank so much for all your help!
I do have another question. I need a formula for the following. An Employee could start on any of these months below but will always have end date of Sep. The Employee could be 1.00 FTE Full-time or 0.50 Part-time this value could change based on the employee status. I'm not sure how to start this formula.