complex nested if formula
Posted on 2014-04-08
Hi Experts excel 2007
Need a if formula to cover the following points
formula to go into cell b2
If c2 has the word, text "completed", then into b2 complete, if c2 has any other word then add that to b2, if c2 is blank then vlookup the value of A2 from mapping table.