Previous Topic Next Topic

Excel Formula help

Closed
JT - Nov 8, 2010 at 02:34 PM
 RayH - Nov 8, 2010 at 03:40 PM
Hello,

I'm trying to create an excel formula to say the following, but can't seem to figure out how to write this formula out.

IF ((A*B)<35000, then sum), IF ((A*B>35000), then 35000)

Does anybody have any advice on this?

Thanks,
JT

1 response

Answer 1 / 1
RayH
Nov 8, 2010 at 03:40 PM
What is A and B? Are these cells? e.g. A1 and B1
What are you SUMmming? A range? e.g. A2:F2


=if(A1*B1<35000,sum(A2:F2),35000)
0

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Calculation of positions in excel
Mohsin -
Dausayi -

12 responses
formulas for 1st and 2nd position in class
jack -
suff954 -

1 response