Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Matt Stanley
 
Posts: n/a
Default 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   Report Post  
Biff
 
Posts: n/a
Default

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   Report Post  
Matt Stanley
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula Dependant Conditional Formatting LDanix Excel Discussion (Misc queries) 1 January 13th 05 07:50 PM
Determine cells that drive conditional formatting? Nicolle K. Excel Discussion (Misc queries) 2 January 7th 05 02:08 AM
Conditional formatting not available in Excel BAB Excel Discussion (Misc queries) 2 January 1st 05 04:33 PM
copy conditional format as ACTUAL format Dana Zulager Excel Discussion (Misc queries) 7 December 8th 04 12:02 AM
Adding more than three Conditions to 'Conditional Formatting' David McRitchie Excel Discussion (Misc queries) 1 November 27th 04 07:03 PM


All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"