luiss Wrote:
Hi, thanks for your reply.
If A1 = 1 and B1 = 0,5 then C1 = 60;
if A1 = 2 and B1 = 0,5 then C1 = 100;
if A1 = 1 and B1 = 1, then C1 = 75;
if A1 = 2 and B1 = 1, then C1 = 125.
Thanks again for your assistance.
Luis
[/color]
Luis,
this formula should be placed in C1.
=IF(AND(A1=1; B1=0,5); 60; IF(AND(A1=2;B1=0,5); 100; IF(AND(A1=1;B1=1);
75; IF(AND(A1=2;B1=1); 125; "SOMETHING WRONG"))))
HTH
Kostis Vezerides
--
vezerid
------------------------------------------------------------------------
vezerid's Profile:
http://www.excelforum.com/member.php...o&userid=28481
View this thread:
http://www.excelforum.com/showthread...hreadid=486047