Cant seem to be able to join two formulas

[alwaysasgood]

Hello to all good people, am happy to be here, using forum for a very long time (not registered). I have a problem that i cant figure out and would appreciate any assistance available.

in screenshot i have cells that might contain the word "single" or might contain a number. What i need is if the word single is present then display the value of cell. If a number is there instead of simple to multiply that same cell value. So far i experimented with the following:

=PRODUCT(IF((E7="single")*(E7="single"),F7,"")) --> shows the F7 value with "single" present
=PRODUCT(IF(E6:E6="single",E6:F6,"")) --> shows the F7 value with "single" present

experimented with & and concatenate but no joy so far. The out come is any of the above or the result of E7*F7

many many thanks

 

[GraH]

Hi @alwaysasgood ,
As a long time follower of the forum you must know we prefer a data sample over a picture.
The explanations you give are very confusing for me. There is no need to use product.

 = (E7 = "Single")*F7

will return the value in F7. Assuming here it's always a number.
Can you upload, using xl2bb add-on, a sample of representative data and the scenarios with expected result. Obviously those do not need to be calculated but clearly explained.

 

[alwaysasgood]

Hi @alwaysasgood ,
As a long time follower of the forum you must know we prefer a data sample over a picture.
The explanations you give are very confusing for me. There is no need to use product.

 = (E7 = "Single")*F7

will return the value in F7. Assuming here it's always a number.
Can you upload, using xl2bb add-on, a sample of representative data and the scenarios with expected result. Obviously those do not need to be calculated but clearly explained.

Hi thanks for the taking the time to help me out. Unfortunately your suggestion is not working

Calculus V6.xlsm
	D	E	F	G	H	I	J	K	L	M	N	O
6	1	1	210	23	1225	5%	€3.99	€5.99	€1.58	€1.78	€3.99	210
7	1	1	350	114	2671	5%	€1.29	€1.29	€1.09	€1.26	€1.29	350
NEW

Cell Formulas
Range	Formula
O6:O7	O6	=IFERROR(VALUE(E6),0)*IFERROR(VALUE(F6),0)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
N6:N1000	Expression	=N6>$J6	text	NO
O6:O1104	Cell Value	=0	text	NO
E6:E1104	Cell Value	>1	text	NO
B6:T1000	Expression	=ROW()=CELL("row")	text	NO
M97:M368,M370:M999,M6:M34,M36:M95	Expression	=ROW()=CELL("row")	text	NO
E370:E999,E5:E368,P6:P999	Cell Value	contains "pck"	text	NO
E370:E999,E5:E368,P6:P999	Cell Value	contains "kg"	text	NO