Hello,
I am attempting to get a logical function to do the following:
In cell G10 I have a formula that tells me the mode of a certain word that will appear based on choices made. I would like the cell beside that to if the word is "maintenance" select the data from cell A11, if it is not then "" or 0. The formula I had attempted to you which seemed as if it should work is =IF(G10="Maintenance",A11,0) with this formula it will only give me 0 even if the text is Maintenance, if I change the order in the formula to =IF(G10="Maintenance",0,A11) then it will only give me the A11 data regardless of which word shows in cell G10.
I am at a loss hoping someone can please help. Can this be done or do I need to be using VBA to do this and using else strings. Please let me know if you have a solution.
Bookmarks