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
Glen46,I think that you are more likely to get an answer if this question was in the Helproom forum.
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).
from the Business forum.
This thread is now locked and can not be replied to.
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 ?
© Copyright 2017 IDG UK. All Rights Reserved.