How do I get a logical formula to add text to a different cell?
I'm checking a large spreadsheet redflagging things in different columns. I want another column telling me if there's any red flags at all in a row.
eg. I need a the NAME (column A) to say something. Column B has
Formula:=if(A1=0, "error","OK")
If it's blank I know about it. How do I get the same formula to add text to something in column R? The object is with several formulas contributing to it I have a summary of redflags. Can post a mockup to explain if it helps.
Bookmarks