![]() This formula will return 2013 as a numeric value if B1 is "Ross" and C1 is 8, or 2012 as a numeric value if B1 is "Block" and C1 is 9. If column B = Ross and column C = 8 then in cell AB of that row I want it to show 2013, If column B = Block and column C = 9 then in cell AB of that row I want it to show 2012.Īnswer:You can create your Excel formula using nested IF functions with the AND function. Question:In Excel, I am trying to create a formula that will show the following: The #AND# function in Qpro can be placed in the middle of a nest and return a number. Question: I need to translate some Quattro Pro functions to Excel.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |