Formula Help

S

SFrick

I have this formula in Row 10 that based on other cells returns;
negative number, Text, positive numbers.

I need a formula to add to row 5 that will return the number 1 if the
cell below in row 10 is greater then or equal to

For example; d10=C

In cell d5 i tried the formula if(d10>=1,1,0) the formula returned 1
when it should have returned 0

Thanks for all help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Newbie Help - IF Yes No Function 0
Use TODAY() function as the criteria in a SUMIF formula 1
Problem with formula for finding last greater than/less than or equal to value 2
Using Roundup in an IF Statement 2
Converting a number into a cell reference 2
Hide columns based on row values 2
Vlookup to reference offset 1
Need help with a formula 3

Top