Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
return a minimum value of 1, except when multiplied by an empty ce
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="Shane Devenshire, post: 3213506"] Hi, If Max(1,Sum($C$1*B2)) works except for the blank cells then you can use =IF($B2,MAX(1,C$1*$B2),0) No need to SUM(C1*B2) here or in any formula. [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Misc
return a minimum value of 1, except when multiplied by an empty ce
Top
