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: 1
Default Temporary Storage in IF function

I have a function like this..
=IF(expr 0 , expr , " ")

Now if my expr is again a big formula.. then is there any way of avoiding
repeating it as the second argument.. ie any temporary variable for storage
is available? like this...

=IF ((a=long_expr) 0 , a , "");
 
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
Data Storage gregory.barrett Excel Discussion (Misc queries) 3 March 30th 06 10:23 PM
CHANGE STORAGE DRIVES margaret@deere Excel Discussion (Misc queries) 3 March 12th 06 10:20 PM
horseracing results database storage hodgy Setting up and Configuration of Excel 0 February 22nd 06 11:27 AM
newbie needs help with data storage mrclox Excel Discussion (Misc queries) 0 November 22nd 05 09:52 PM
data storage from one worksheet to another coal_miner Excel Worksheet Functions 3 May 3rd 05 04:42 PM


All times are GMT +1. The time now is 04:54 AM.

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"