I need help with a conditional formula

  • Thread starter Thread starter trib
  • Start date Start date
T

trib

I need to find a formula for the following:

If there is a value higher than 10 in the range (A..:A..), multiply
each of the values by 2 and show their resulting sum.

I appreciate your time and help


+-------------------------------------------------------------------+
|Filename: sample_file.doc |
|Download: http://www.excelforum.com/attachment.php?postid=5202 |
+-------------------------------------------------------------------+
 
Thank you for your swift response.

However, I need to have multiplied by 2 only those values in the range
which are higher than 10.

Using your formula I get 90. In my example (see sample file) I should
get 44
 
Back
Top