Aug 14 2021 09:25 PM - edited Aug 14 2021 09:39 PM
Aug 14 2021 09:49 PM
@dianakay The formula in the photo seem to use structured table references, but are you indeed working with such structured tables where the column headers are exactly as used in the formula? That is, "Operating_Income" and "Net_Sales", both with the underscore.
Perhaps you can upload the workbook instead!
Aug 14 2021 10:18 PM
Aug 14 2021 10:29 PM
@dianakay I'm not doubting that you exactly did as instructed, but the message you showed in your first post indicated that something was entered in a way that Excel doesn't like or recognize.
Upload your workbook instead of huge PDFs, please.
Aug 14 2021 10:35 PM - edited Aug 14 2021 10:40 PM
@dianakay Just noticed now that the instruction does not include the underscore in the column names where the formula you tried to enter does have underscores. Furthermore, the green table in the instructions is indeed a structured tables where as the one you seem to be working on is not.