| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can multiple criteria be used for IF formulas?
I am using the below formula to calculate percent of change from one year to
another year. =IF(F3=0,1,U3/F3-1) F3 being the amount spent in previous year U3 being amount spent in current year The question I want my formula to answer is: If F3 and U3 have a quotient greater than zero, then calculate. However, I also want it to yield a 100 answer if the F3 is zero AND I also want it to yield 0 if both F3 and U3 are zero. -- Thanks, Christine |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Can multiple criteria be used for IF formulas?
Please see responses to your later reposting.
----- original message ----- "CHaney" wrote: I am using the below formula to calculate percent of change from one year to another year. =IF(F3=0,1,U3/F3-1) F3 being the amount spent in previous year U3 being amount spent in current year The question I want my formula to answer is: If F3 and U3 have a quotient greater than zero, then calculate. However, I also want it to yield a 100 answer if the F3 is zero AND I also want it to yield 0 if both F3 and U3 are zero. -- Thanks, Christine |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help w/ formulas for multiple criteria | Excel Worksheet Functions | |||
| Excel Formulas with multiple criteria | Excel Discussion (Misc queries) | |||
| How do I put multiple criteria in LOOKUP formulas | Excel Worksheet Functions | |||
| Array Formulas with multiple criteria in the same row? | Excel Worksheet Functions | |||
| multiple criteria for formulas | Excel Discussion (Misc queries) | |||
Hybrid Mode
