| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible | Excel Discussion (Misc queries) | |||
| Build excel formula using field values as text in the formula | Excel Worksheet Functions | |||
| match formula - 2 excel files:#1 hasthis formula, 2nd has the Raw | Excel Worksheet Functions | |||
| Excel 2002 formula displayed not value formula option not checked | Excel Worksheet Functions | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
![m4d Ir15h[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
