M
matt4003
Hi everyone,
I think this is an easy thing to do, but I have not had any luck.
Basically, I am building a small tool to do price scenerio's based on
criteria. I have been able to get criteria A-D to product the correc
answer using the below formula:
=LOOKUP($C4,Summary!$A$12:$A$15,(((Summary!$B$12:$B$15)*$D4)+$D4))
It basically says if criteria is X then multiple Y time D4 (origina
price) to get price change, then add back to D4 to get new price.
The problem is criteria E needs to be referenced in a different place.
So if criteria (C4) = E, then multiply J4 by D4 to get price change
then add back to D4 to get new price.
I am having a hard time combining these two concepts...do I use an I
statement, an OR...??
Anyone have any ideas??
Thanks in advance.
Cheers,
Matt :confused
I think this is an easy thing to do, but I have not had any luck.
Basically, I am building a small tool to do price scenerio's based on
criteria. I have been able to get criteria A-D to product the correc
answer using the below formula:
=LOOKUP($C4,Summary!$A$12:$A$15,(((Summary!$B$12:$B$15)*$D4)+$D4))
It basically says if criteria is X then multiple Y time D4 (origina
price) to get price change, then add back to D4 to get new price.
The problem is criteria E needs to be referenced in a different place.
So if criteria (C4) = E, then multiply J4 by D4 to get price change
then add back to D4 to get new price.
I am having a hard time combining these two concepts...do I use an I
statement, an OR...??
Anyone have any ideas??
Thanks in advance.
Cheers,
Matt :confused