Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Unwanted formula being copied to cell | Excel Discussion (Misc queries) | |||
Unwanted result | Excel Discussion (Misc queries) | |||
Advanced formula - Return result & Show Cell Reference of result | Excel Worksheet Functions | |||
Median result used in formula gives incorrect result | Excel Worksheet Functions | |||
Unwanted LOOKUP() Result | Excel Discussion (Misc queries) |