Forum Discussion
Solved
Giving names values
Hi, I'm trying to give names values on excel. I have a list of a few combinations and I want to do a multiplication after. Here is my document, if someone could help me I would really appreciate it. ...
- I hope I understood what you are looking for...
Try this formula
=IF(B10=B$2;B$5;B$6)*IF(C10=C$2;C$5;C$6)*IF(D10=D$2;D$5;D$6)*IF(E10=E$2;E$5;E$6)*IF(F10=F$2;F$5;F$6)*IF(G10=G$2;G$5;G$6)
I hope I understood what you are looking for...
Try this formula
=IF(B10=B$2;B$5;B$6)*IF(C10=C$2;C$5;C$6)*IF(D10=D$2;D$5;D$6)*IF(E10=E$2;E$5;E$6)*IF(F10=F$2;F$5;F$6)*IF(G10=G$2;G$5;G$6)
Try this formula
=IF(B10=B$2;B$5;B$6)*IF(C10=C$2;C$5;C$6)*IF(D10=D$2;D$5;D$6)*IF(E10=E$2;E$5;E$6)*IF(F10=F$2;F$5;F$6)*IF(G10=G$2;G$5;G$6)