Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Conditional if statement
I have a spreadsheet that needs to calculate the annual cost of a service
based on whether the metric is weekly or monthly. For example, one column has a flat rate; the next column has a pulldown list with the options "Weekly" or "Monthly;" the last column is for annual cost. This last column should check to see if the value of the second column is "Weekly" or "Monthly" and calculate the annual cost accordingly... If it's weekly, then the last column should multiply the first column by 52, but if it's monthly, then the last column should multiple the first column by 12. How do I do this??? TIA, Stan |
#2
|
|||
|
|||
Hi!
Here's one way: =IF(B1="","",IF(B1="Weekly",A1*52,A1*12)) Assume that the dropdown is in column B and the value to multiply is in column A. Biff -----Original Message----- I have a spreadsheet that needs to calculate the annual cost of a service based on whether the metric is weekly or monthly. For example, one column has a flat rate; the next column has a pulldown list with the options "Weekly" or "Monthly;" the last column is for annual cost. This last column should check to see if the value of the second column is "Weekly" or "Monthly" and calculate the annual cost accordingly... If it's weekly, then the last column should multiply the first column by 52, but if it's monthly, then the last column should multiple the first column by 12. How do I do this??? TIA, Stan . |
#3
|
|||
|
|||
Thanks!
"Biff" wrote in message ... Hi! Here's one way: =IF(B1="","",IF(B1="Weekly",A1*52,A1*12)) Assume that the dropdown is in column B and the value to multiply is in column A. Biff -----Original Message----- I have a spreadsheet that needs to calculate the annual cost of a service based on whether the metric is weekly or monthly. For example, one column has a flat rate; the next column has a pulldown list with the options "Weekly" or "Monthly;" the last column is for annual cost. This last column should check to see if the value of the second column is "Weekly" or "Monthly" and calculate the annual cost accordingly... If it's weekly, then the last column should multiply the first column by 52, but if it's monthly, then the last column should multiple the first column by 12. How do I do this??? TIA, Stan . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Dependant Conditional Formatting | Excel Discussion (Misc queries) | |||
Determine cells that drive conditional formatting? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Adding more than three Conditions to 'Conditional Formatting' | Excel Discussion (Misc queries) |