Both versions average calculation time is exactly the same*: 0.00023 secs

* using Charles Williams' RangeTimer method.

http://msdn2.microsoft.com/en-us/library/aa730921.aspx

Biff

"JLatham" <HelpFrom @ Jlathamsite.com.(removethis) wrote in message
...
Judging by the other inputs, you get top points for Orginality and are
well
up the scale on Execution. Very good!

"Gary''s Student" wrote:

=(A1="red")*(A2="blue")*10+(A1="green")*(A2="orang e")*20+(A1="purple")*(A2="yellow")*30


no IFs are needed.
--
Gary's Student
gsnu200706


"Shelly" wrote:

Hello - I've searched, but cannot find what I'm looking for... I need
to do
this:

In the cell A3 the formula should say

If A1 = "red" and if A2 = "blue" enter 10 in A3, or
If A1 = "green" and if A2 = "orange" enter 20 in A3, or
If A1 = "purple" and if A2 = "yellow" enter 30 in A3.

And, I will need to replicate this down a column of 5 rows.

THANKS!!