Forum Discussion

Copper Contributor

Feb 15, 2023

Solved

Help with Excel - Calculating 2 cells based on the text within another

Hello ! I hope someone can help me 🙂 My issue is, I need to calculate the multiplication of 2 cells, when a completely different cell returns a specific text. Eg: Cell A = 10 Cell B = 5 ...

excel

SergeiBaklan
Feb 15, 2023
Johnny_The_Muz

Perhaps

=IF(C1="HAT", A1*B1, "")

OliverScheurich

Gold Contributor

Feb 15, 2023

Johnny_The_Muz

=IF(C1="HAT",A1*B1,IF(C1="Trousers","",""))

You can try this nested IF formula.

Johnny_The_Muz

Copper Contributor

Feb 15, 2023

This was so fast ... Thank you so much for the quick response.. This formula worked perfectly.
Thank you so very much.