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: 11
Default If then else needed in Excel 2007

Ok, here's a reall good one: Here is what I need:

Cell C3 may or may not contain text. If it does, then I want cell C4's
numeric data (which is currently a positive number) to be a negative number
instead.

Example:

C3=CR
C4=100.00
I want cell C4 to be -100.00 instead of 100.00

Does this make sense?
Any Excel heads out there that can help will be GREATLY appreciated.

CG

Right now I have
--
CLG
 
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
Urgent help needed!!! Saving in Excel 2007 Cazzy123 Excel Discussion (Misc queries) 3 November 4th 09 11:28 PM
Testers needed for code page : create and mail PDF files in Excel 2007 with the MS PDF add-in Ron de Bruin Excel Discussion (Misc queries) 2 February 28th 09 01:37 PM
Excel 2007 Right Hand Mouse button problem - Help Needed Robbie Excel Discussion (Misc queries) 4 December 18th 08 09:01 AM
Help needed with creating a Formula in Excel 2007 please ? Gerry1234567 Excel Worksheet Functions 11 December 9th 08 09:26 PM
lower case to Proper help needed in Excel Office 2007 dinee Excel Worksheet Functions 4 November 1st 07 08:09 PM


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