if formula needed to populate either "1" or "0" based on number of units in another cell

**excelteam777** · 06-07-2015, 10:19 AM

Hello,

I need an "if" formula.

Basically if C2 equals 8 or less then B2 will populate with "1"

If C2 equals 9 or higher then B2 will populate with "0"

**TMS** · 06-07-2015, 10:20 AM

Formula:

Please Login or Register  to view this content.

Regards, TMS

**excelteam777** · 06-07-2015, 10:23 AM

Thank You, i appreciate it

**TMS** · 06-07-2015, 11:24 AM

You're welcome.

if formula needed to populate either "1" or "0" based on number of units in another cell

LinkBack

Thread Tools

Rate This Thread

Display

if formula needed to populate either "1" or "0" based on number of units in another cell

Re: if formula needed to populate either "1" or "0" based on number of units in another ce

Re: if formula needed to populate either "1" or "0" based on number of units in another ce

Re: if formula needed to populate either "1" or "0" based on number of units in another ce

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] VBA help needed to remove all "/" then replace with "-" from cell "B3"and "B5"

[SOLVED] Formula Needed to fill multiple cells with "No" when the word "No" is entered into a cell

[SOLVED] Formula needed to display "Pass" or "Fail" if a column contains any values other than "yes

[SOLVED] How to Count number of "Error" and "OK" after the word "Instrument" found in table row

Formula returning result of "True" or "False" instead of "1" or "0"

Bookmarks

Bookmarks

Posting Permissions