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: 127
Default Formula gives unwanted result

Hi Experts:

I've poured over the other questions and responses on this site and either
missed my situation or it's not there...I need help with what should be so
simple...

Example: B13 is 20...I want C13 to give me the result of 3 of B13 is
greater than 17....I then need the formula to say...If B13 is not greater
than 17, enter 0.

This formula that I've started returns the result of 1 not 3...I then need
to expand the formula to enter zero if B13 is not greater than 17. The
result would be returned in C13.

=SUM($B1317)

I know this is really simple, so be kind....my brain is fried....

Thank you so much for all your expertise.....
--
jeannie v
 
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
Unwanted formula being copied to cell Gene Excel Discussion (Misc queries) 3 April 17th 07 06:02 PM
Unwanted result Patrick C. Simonds Excel Discussion (Misc queries) 3 February 22nd 07 05:36 PM
Advanced formula - Return result & Show Cell Reference of result Irv Excel Worksheet Functions 7 May 6th 06 03:36 AM
Median result used in formula gives incorrect result vlatham Excel Worksheet Functions 4 September 21st 05 04:26 PM
Unwanted LOOKUP() Result Sympatico News Excel Discussion (Misc queries) 1 July 30th 05 02:51 AM


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