LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 3
Default Formula creation

Using XP and Excel 2003-how do I create a formula for the following outcome:
Cell A3 is nil, cell B3 has a value of say $500.00. I want to add cell B3 to
say cell B6 which has a value of say $1000, but if cell A3 has a value and B3
is nil I want to subtract A3 value from B6.
 
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
Suppress automatic formula creation? Geoff C Excel Worksheet Functions 2 March 28th 07 08:46 AM
Dynamic Formula Creation?? [email protected] Excel Discussion (Misc queries) 2 October 27th 06 09:14 AM
Creation Date Kjell Forssen Excel Discussion (Misc queries) 4 June 3rd 06 11:46 AM
Formula creation...if possible Kelly C Excel Worksheet Functions 2 February 22nd 06 11:11 PM
Template Creation Tee Excel Worksheet Functions 1 January 27th 06 11:16 AM


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