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: 7
Default conditional formula

can someone please show me an example of a formula that would allow a value
to be placed in a cell from a formula I have written, only if the answer is
positive, otherwise it would put a zero as the answer? For example, if I had
a formula that added two cells together, if the result was a positive number,
I want that number in the cell, but if the answer is a negative number,
instead of that negative number, I want a zero in the cell.
--
craig
 
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
Formula, Conditional Formula Needed Karl Excel Discussion (Misc queries) 12 June 23rd 07 04:12 AM
conditional formula Karen Hunter Excel Discussion (Misc queries) 4 June 4th 07 08:25 PM
conditional formula Rose Davis Excel Worksheet Functions 2 October 21st 06 12:40 AM
Conditional Formula to indicate Formula in cell SteveW New Users to Excel 9 August 2nd 06 01:12 AM
Help with a conditional formula Tracey Excel Worksheet Functions 5 June 29th 05 04:20 PM


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