Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Overriding formula

I have a if formula in a cell, but need to override it from another cell.
what formula can I use.
--
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,651
Default Overriding formula

=IF(override_cell="Yes","Value overridden",your_formula)
--
David Biddulph

KANDLEZ wrote:
I have a if formula in a cell, but need to override it from another
cell. what formula can I use.




  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 22,906
Default Overriding formula

Formulas return results to the cell in which they are written.

Please explain in more detail what you want to do.

Post the formula you have and which cell it is in.

Post the address of the "another cell"


Gord Dibben MS Excel MVP

On Tue, 19 May 2009 13:14:01 -0700, KANDLEZ
wrote:

I have a if formula in a cell, but need to override it from another cell.
what formula can I use.


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
conditional format overriding border Teresa Excel Discussion (Misc queries) 0 April 30th 08 05:08 PM
Overriding zero-strings with previous line constant Jim May Excel Discussion (Misc queries) 2 April 10th 08 02:58 PM
New Conditional Format Overriding Previous Conditional Format Rene Excel Discussion (Misc queries) 3 February 27th 08 06:08 PM
Using Invoice template: overriding formulae Enigmaman Excel Discussion (Misc queries) 2 November 24th 05 05:25 PM
MACRO FOR SETTING MARGINS WITHOUT OVERRIDING HEADER AND FOOTER Ro Excel Discussion (Misc queries) 0 March 30th 05 02:31 PM


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