he following formula:
=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))))

Works well if the first condition B3=8 is met and returns the correct value.
The problem is that when that condition is not met the formula returs FALSE,
I want it to print 0. Every option I have tried has failed. The error always
says to many arguments have been entered.

Thanks in advance for any help.

Have you tried
=b6*12/b7

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Gulfman100" wrote in message
...
he following formula:
=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))))

Works well if the first condition B3=8 is met and returns the correct
value.
The problem is that when that condition is not met the formula returs
FALSE,
I want it to print 0. Every option I have tried has failed. The error
always
says to many arguments have been entered.

Thanks in advance for any help.

Hi,
Try adding a 0 to the closing ")"

=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))),0)


John


"Gulfman100" wrote in message ...
he following formula:
=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))))

Works well if the first condition B3=8 is met and returns the correct value.
The problem is that when that condition is not met the formula returs FALSE,
I want it to print 0. Every option I have tried has failed. The error always
says to many arguments have been entered.

Thanks in advance for any help.

try adding a 0 at the end of the formula

=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))),0)

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"Gulfman100" wrote:

he following formula:
=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))))

Works well if the first condition B3=8 is met and returns the correct value.
The problem is that when that condition is not met the formula returs FALSE,
I want it to print 0. Every option I have tried has failed. The error always
says to many arguments have been entered.

Thanks in advance for any help.

This is a little shorter:

=IF(B3<8,0,((3*B8)+(4*B9)+(8*B10))+B6*((B7=16)*0. 75+((B7=24)*0.5)))

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Gulfman100" wrote in message
...
he following formula:

=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B
8)+(4*B9)+(B10*8),0))))

Works well if the first condition B3=8 is met and returns the correct
value.
The problem is that when that condition is not met the formula returs
FALSE,
I want it to print 0. Every option I have tried has failed. The error
always
says to many arguments have been entered.

Thanks in advance for any help.

Left out a condition.
By the time I added it in, this is only slightly shorter:

=IF(B3<8,0,IF(OR(B7={16,24}),((3*B8)+(4*B9)+(8*B1 0))+B6*((B7=16)*0.75+((B7=
24)*0.5)),0))
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Ragdyer" wrote in message
...
This is a little shorter:

=IF(B3<8,0,((3*B8)+(4*B9)+(8*B10))+B6*((B7=16)*0. 75+((B7=24)*0.5)))

--
HTH,

RD

--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit !
--------------------------------------------------------------------------
-

"Gulfman100" wrote in message
...
he following formula:


=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B
8)+(4*B9)+(B10*8),0))))

Works well if the first condition B3=8 is met and returns the correct
value.
The problem is that when that condition is not met the formula returs
FALSE,
I want it to print 0. Every option I have tried has failed. The error
always
says to many arguments have been entered.

Thanks in advance for any help.

That works, Thank you!
Best Wishes

"xlmate" wrote:

try adding a 0 at the end of the formula

=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))),0)

HTH
--
Pls provide your feedback by clicking the Yes button below if this post have
help you. This will help others to search the archives for result better.


Thank You

cheers, francis









"Gulfman100" wrote:

he following formula:
=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))))

Works well if the first condition B3=8 is met and returns the correct value.
The problem is that when that condition is not met the formula returs FALSE,
I want it to print 0. Every option I have tried has failed. The error always
says to many arguments have been entered.

Thanks in advance for any help.

That Works, THANKS!

"jaf" wrote:

Hi,
Try adding a 0 to the closing ")"

=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))),0)


John


"Gulfman100" wrote in message ...
he following formula:
=IF(B3=8,IF(B7=16,(B6*12/16)+(3*B8)+(4*B9)+(8*B10),(IF(B7=24,(B6*12/24)+(3*B8)+(4*B9)+(B10*8),0))))

Works well if the first condition B3=8 is met and returns the correct value.
The problem is that when that condition is not met the formula returs FALSE,
I want it to print 0. Every option I have tried has failed. The error always
says to many arguments have been entered.

Thanks in advance for any help.