XCEL formula needed to return multiplication

Solved/Closed

todd - May 3, 2010 at 12:03 AM
Trowa - May 3, 2010 at 08:03 AM

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!

XCEL formula needed to return multiplication
How to apply formula in excel to multiple sheets - Guide
Excel formula if cell contains multiple text ✓ - Forum - Excel
Excel formula if cell contains text then return value in another cell ✓ - Forum - Excel
Excel formula if two cells match return value from third ✓ - Forum - Excel
Excel formula if cell contains date then return date in another cell ✓ - Forum - Office Software

1 reply

Answer 1 / 1

Trowa
May 3, 2010 at 08:03 AM

Here you go Todd:

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

Best regards,
Trowa

Subscribe To Our Newsletter!