Help Me Y'all! (Nested If functions)

Aspose.Cells Product Family
1

I’m doin a playoff project in excel and one of my formulas is:

=IF(C9>E9,“Miami”,IF(C9=E9,"",“Atlanta”))

The formula works, but the problem is that “Miami” and “Atlanta” need to be variable, and show the result of whatever team is shown in cell B7 or E7. What can i enter instead of those examples into the speachmarks to make it show whats in those cells without changing the formula.

Thank you for your help

2

Hi, I don’t understand your question clearly.

How about “=IF(C9>E9, B7,IF(C9=E9,”",E7)) "?

3

@half_baked_russian,
Thank you for considering Aspose.Excel in the past and would like to share that we have discontinued Aspose.Excel and introduced a much more efficient and feature-rich library Aspose.Cells. This library contains lof of exciting features and supports all the functionalities in the latest versions of MS Excel. You can use NEsted if function in this new product also using the following sample code:

var book = new Workbook();
book.Worksheets[0].Cells["A1"].PutValue("10x12");
book.Worksheets[0].Cells["A2"].PutValue("8x8");
book.Worksheets[0].Cells["A3"].PutValue("6x6");
book.Worksheets[0].Cells["A4"].Formula = "= IF(A1 =\"10x12\", 120, IF(A1 =\"8x8\", 64, IF(A1 =\"6x6\", 36)))";
book.CalculateFormula();
book.Save("output.xlsx", Aspose.Cells.SaveFormat.Xlsx);

For more information on opening different versions of Excel files, please follow the link below:
Formulas

Download the latest version of Aspose.Cells for .NET from the following link:
Aspose.Cells for .NET (Latest Version)

You can download the latest demos here.