LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 150
Default IF hypotheticals that are not TRUE/FALSE response

I have a number of formulas which calculate based on the input of 'Agents'.
Agents= {1,2,3,4,5,6,7,8,9,10}. I would like an output of these formulas
based on all instances of 'Agents'.

Specifically, the cell D18 is a SUM calculation of overhead costs. The
cells in the SUM calculation are predicated on cell F3. (Agents). D18
recalculates for each instance of F3. I am trying to output a table of each
of these results, simultaneously.

stan stadelman
excel 2003, windows xp pro

 
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
Return True/False to check duplicate items in a range with one for Tetsuya Oguma Excel Worksheet Functions 10 October 21st 06 03:20 AM
Replacing #N/A response when obtained in Lookup function CochranConsult Excel Worksheet Functions 4 June 26th 06 04:03 PM
Multiple search criteria to return one response Dan Excel Worksheet Functions 3 March 3rd 06 03:44 AM
polar response DaveT Excel Discussion (Misc queries) 1 November 4th 05 03:29 AM
macro that brings user to cell based on "yes/no" response lennyx2 Excel Discussion (Misc queries) 2 February 9th 05 02:47 PM


All times are GMT +1. The time now is 12:40 PM.

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

About Us

"It's about Microsoft Excel"