'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi All

Please help...

I am trying to create a formula that captures a certain cell's value IF it
is equal to or lower than 0 (zero). I am also trying to reverse this formula
for another section.

Can someone please provide a suggestion on this? I have been trying to
figure this one out for the last four hours and am still having no luck.

I am trying to use both IF and COUNTIF for these formlas. Is this correct
or should I be using another sum?

Cheers

Paul
 
You must log in or register to reply here.

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

Excel Need Countifs Formula Help 0
Excel formula, sum the value cell and if empty cell left blank 0
CountIf previous cell formula 0
IF Function error #VALUE 2
Count range of cells if not next to each other 0
IF AND Nested Functions - Formula Not Working 0
Excel Use COUNTIF across a range of cells with formulas 0
sumif formula to calculate value of cell if certain criteria are m 5

Back
Top