Previous Topic Next Topic

Excel Formula help

Closed
JT - 8 Nov 2010 à 14:34
 RayH - 8 Nov 2010 à 15:40
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

Réponse 1 / 1
RayH
8 Nov 2010 à 15:40
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)

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