Previous Topic Next Topic

XCEL formula needed to return multiplication

Solved/Closed
todd - 3 May 2010 à 00:03
 Trowa - 3 May 2010 à 08:03
I need a formula that does the following:

if b10 is => than 10.03 AND c10 is => than 6.69, then multiply b10 times 328

It seems simple, but I jet cant figure it out!

Related:

1 response

Réponse 1 / 1
Trowa
3 May 2010 à 08:03
Here you go Todd: 

=IF(B10>=10.03,IF(C10>=6.69,B10*328,""),"")
Best regards,
Trowa

Similar discussions

WOW equipment return
aakash12345_0667 -
HelpiOS -

1 response
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
VBA Macro Matrix Multiplication with a scalar
VBAConfused -
MANMANI -

6 responses