Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 55
Default Different actions on a pivotal value

I'd like to execute a formula in a cell based on the value of another cell.
In my case the cell used as a reference can be one out of 5 values. Using
nested IF doesn't seem a clean and efficient solution. Is there anything more
elegant? Something like ON variable value - distinct outcomes.

Thanks, Stefano
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
pivotal table problem Vijay Kotian Excel Discussion (Misc queries) 1 November 16th 06 12:23 AM
Repeat actions not working Ken G. Excel Discussion (Misc queries) 1 July 12th 06 07:54 AM
Using non standard actions on an Excel 97 pivot table Hackensack Excel Discussion (Misc queries) 2 April 3rd 06 07:27 PM
pivotal analysis? Paul Thomas Excel Discussion (Misc queries) 2 November 14th 05 05:16 PM
Repeat Code Repetitive Actions? chris Excel Discussion (Misc queries) 2 February 18th 05 11:30 PM


All times are GMT +1. The time now is 05:04 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"