Excel Formula

  Glen46 15:28 28 Jul 2009
Locked

Could someone please help I need a formula to calculate a sum if i put a figure in a cell up to 10000 I want to multiply this by 40 anything over 10000 I want to multiply the first 10000 by 40 and the rest by 25 can anyone help

  avesnes1 16:15 28 Jul 2009

Glen46,
I think that you are more likely to get an answer if this question was in the Helproom forum.

  bstb3 19:36 28 Jul 2009

he's right you know, but anyway:

=IF(A1>=10000,400000+(A1-10000)*25,A1*40)

assuming the figure you want to multiply is in cell A1 (otherwise just change A1 to whatever cell you need).

  Forum Editor 23:31 28 Jul 2009

from the Business forum.

This thread is now locked and can not be replied to.

Elsewhere on IDG sites

OnePlus 5 review

See the work of famous artists playing with toys

iPad Pro 10.5in (2017) review

Comment faire une capture d’écran sur un Mac ?