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

I am trying to create a formula where if C390 then add c7+ C8+ c9 and place
the result in cell c37.
I know this is not a difficult one but I rarely do if then statements.
Thank you for your help in advance.
Greg

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 11,501
Default Conditional formula

Try this

=IF(C390,SUM(C7:C9),"")

Mike

"Greg" wrote:

I am trying to create a formula where if C390 then add c7+ C8+ c9 and place
the result in cell c37.
I know this is not a difficult one but I rarely do if then statements.
Thank you for your help in advance.
Greg

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 formula Mindy Excel Worksheet Functions 13 July 30th 08 08:36 PM
Excel 2002 Formula: Urgent Conditional Formula Required Right Away - if possible blue[_2_] Excel Discussion (Misc queries) 2 July 11th 07 06:08 PM
Formula, Conditional Formula Needed Karl Excel Discussion (Misc queries) 12 June 23rd 07 04:12 AM
Conditional Formula to indicate Formula in cell SteveW New Users to Excel 9 August 2nd 06 01:12 AM
Conditional Formula DeeExpus Excel Discussion (Misc queries) 3 May 5th 06 11:17 AM


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