Need Help with an Excel Formula!
 

I have been trying to work on this for a while... and I hope I can get some
help.

basically, what I am working on is a type of checker.

Here is what I have come up with...

=IF((OR(B7=1,B8=1)),"15.00","00.00")

basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the following:

B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00

Get what I mean?

Need Help with an Excel Formula!
 

If my understanding is correct use it on c7 and copy to c8

=IF(AND(B7=0.01,B8=0),B7+15,IF(AND(B7=0,B8=0.01) ,B7+15,IF(AND(B7=0.01,B8=0.01),B7+30)))


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"m4d Ir15h" escreveu:

I have been trying to work on this for a while... and I hope I can get some
help.

basically, what I am working on is a type of checker.

Here is what I have come up with...

=IF((OR(B7=1,B8=1)),"15.00","00.00")

basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the following:

B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00

Get what I mean?

Need Help with an Excel Formula!
 

Try this:

=COUNTIF(B7:B8,"0")*15

--
Biff
Microsoft Excel MVP


"m4d Ir15h" wrote in message
...
I have been trying to work on this for a while... and I hope I can get some
help.

basically, what I am working on is a type of checker.

Here is what I have come up with...

=IF((OR(B7=1,B8=1)),"15.00","00.00")

basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the
following:

B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00

Get what I mean?

Need Help with an Excel Formula!
 

one way.......


=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

--
Greetings from New Zealand

"m4d Ir15h" wrote in message
...
I have been trying to work on this for a while... and I hope I can get some
help.

basically, what I am working on is a type of checker.

Here is what I have come up with...

=IF((OR(B7=1,B8=1)),"15.00","00.00")

basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the
following:

B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00

Get what I mean?

Need Help with an Excel Formula!
 

Actually... that works great...
but one final question on that formula... what do you have to do to make it
say 0.00 instead of False if nothing has been entered in one one of those
specific cells (suchs as B7 of B8)?

"Marcelo" wrote:

If my understanding is correct use it on c7 and copy to c8

=IF(AND(B7=0.01,B8=0),B7+15,IF(AND(B7=0,B8=0.01) ,B7+15,IF(AND(B7=0.01,B8=0.01),B7+30)))


hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"m4d Ir15h" escreveu:

I have been trying to work on this for a while... and I hope I can get some
help.

basically, what I am working on is a type of checker.

Here is what I have come up with...

=IF((OR(B7=1,B8=1)),"15.00","00.00")

basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the following:

B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00

Get what I mean?

Need Help with an Excel Formula!
 

WoW...

thanks guys... I appreciate the help!

"Bill Kuunders" wrote:

one way.......


=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

--
Greetings from New Zealand

"m4d Ir15h" wrote in message
...
I have been trying to work on this for a while... and I hope I can get some
help.

basically, what I am working on is a type of checker.

Here is what I have come up with...

=IF((OR(B7=1,B8=1)),"15.00","00.00")

basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the
following:

B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00

Get what I mean?

Need Help with an Excel Formula!
 

What if I wanted to add a third item in the following formula?

=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

For istance, if it would include B6, B7, B8...? so for each cell that had a
value greater than zero would add $15.00 to a total?

In other words...

If 1 of the 3 cells were filled... then it would add $15.

If 2 of the 3 were filled, it would add $30.00...

and if all three were filled, then it would add $45.00?



"Bill Kuunders" wrote:

one way.......


=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

--
Greetings from New Zealand

"m4d Ir15h" wrote in message
...
I have been trying to work on this for a while... and I hope I can get some
help.

basically, what I am working on is a type of checker.

Here is what I have come up with...

=IF((OR(B7=1,B8=1)),"15.00","00.00")

basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the
following:

B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00

Get what I mean?

Need Help with an Excel Formula!
 

One way:


=COUNT(B6:B8)*15

In article ,
m4d Ir15h wrote:

What if I wanted to add a third item in the following formula?

=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

For istance, if it would include B6, B7, B8...? so for each cell that had a
value greater than zero would add $15.00 to a total?

In other words...

If 1 of the 3 cells were filled... then it would add $15.

If 2 of the 3 were filled, it would add $30.00...

and if all three were filled, then it would add $45.00?



"Bill Kuunders" wrote:

one way.......


=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

--
Greetings from New Zealand

"m4d Ir15h" wrote in message
...
I have been trying to work on this for a while... and I hope I can get some
help.

basically, what I am working on is a type of checker.

Here is what I have come up with...

=IF((OR(B7=1,B8=1)),"15.00","00.00")

basically, this states that if there is something in B7 then, it would add
$15.00... or if there is something in B8, then it would also add $15.00,
which is great. But what I need that formula to basically do is the
following:

B7 with a value greater than Zero and b8 = Zero, add $15.00
B8 with a value greater than Zero and b7 = Zero, add $15.00
B8 AND B7 has a value greater than Zero, add $30.00

Get what I mean?

Need Help with an Excel Formula!
 

Oops - I answered "were filled", rather than "greater than zero". For
the latter, one way:

=COUNTIF(B6:B8,"0")*15

In article ,
m4d Ir15h wrote:

What if I wanted to add a third item in the following formula?

=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

For istance, if it would include B6, B7, B8...? so for each cell that had a
value greater than zero would add $15.00 to a total?

In other words...

If 1 of the 3 cells were filled... then it would add $15.

If 2 of the 3 were filled, it would add $30.00...

and if all three were filled, then it would add $45.00?

Need Help with an Excel Formula!
 

oh....!

thats so much easier!
lol...

thanks alot!

"JE McGimpsey" wrote:

Oops - I answered "were filled", rather than "greater than zero". For
the latter, one way:

=COUNTIF(B6:B8,"0")*15

In article ,
m4d Ir15h wrote:

What if I wanted to add a third item in the following formula?

=IF(AND((B7+B8)0,(B7*B8)=0),15,IF(AND(B70,B80), 30,0))

For istance, if it would include B6, B7, B8...? so for each cell that had a
value greater than zero would add $15.00 to a total?

In other words...

If 1 of the 3 cells were filled... then it would add $15.

If 2 of the 3 were filled, it would add $30.00...

and if all three were filled, then it would add $45.00?