| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
where can I find help with excel formulas?
I need a formula to fit this case...if a1=40 and b1<=6 then c1=250
What I'm trying to do is if A1 is 40 or more customers and B1 is 6 hours or less, then C1 will equate to 250. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
where can I find help with excel formulas?
What do you want to do if those conditions are not met?
Enter this formula in C1: =IF(AND(A1=40,B1<=6),250,0) If the conditions aren't met the formula will return 0. Biff "trying to learn" <trying to wrote in message ... I need a formula to fit this case...if a1=40 and b1<=6 then c1=250 What I'm trying to do is if A1 is 40 or more customers and B1 is 6 hours or less, then C1 will equate to 250. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
where can I find help with excel formulas?
Biff, what you wrote is perfect. If the conditions are not met, then 0 was
what I wanted. Thank you very much for your assistance! "Biff" wrote: What do you want to do if those conditions are not met? Enter this formula in C1: =IF(AND(A1=40,B1<=6),250,0) If the conditions aren't met the formula will return 0. Biff "trying to learn" <trying to wrote in message ... I need a formula to fit this case...if a1=40 and b1<=6 then c1=250 What I'm trying to do is if A1 is 40 or more customers and B1 is 6 hours or less, then C1 will equate to 250. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
where can I find help with excel formulas?
You're welcome. Thanks for the feedback!
Biff "trying to learn" wrote in message ... Biff, what you wrote is perfect. If the conditions are not met, then 0 was what I wanted. Thank you very much for your assistance! "Biff" wrote: What do you want to do if those conditions are not met? Enter this formula in C1: =IF(AND(A1=40,B1<=6),250,0) If the conditions aren't met the formula will return 0. Biff "trying to learn" <trying to wrote in message ... I need a formula to fit this case...if a1=40 and b1<=6 then c1=250 What I'm trying to do is if A1 is 40 or more customers and B1 is 6 hours or less, then C1 will equate to 250. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| where can i find Formulas for excel 2000? | Excel Worksheet Functions | |||
| my excel formulas are too long to execute find and replace | Excel Worksheet Functions | |||
| Excel should let me use formulas that refer to other cells w/ form | Excel Worksheet Functions | |||
| Hints And Tips For New Posters In The Excel Newsgroups | Excel Worksheet Functions | |||
| How do I get to master Excel functions and formulas? | Excel Worksheet Functions | |||
Linear Mode
