Formula

  • Thread starter Thread starter Scott
  • Start date Start date
S

Scott

I am trying to create the following formula:
if b2 is "no, then b6-b9, otherwise, b6-b9 but not less
than zero.

I think I have this correct until I get to the "but not
less than zero" part.

=if(b2="no",b6-b9,b6-b9 but not less than zero)

Thanks
 
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

Code copies ONLY last j from sheet 9
Counting Work Days 5
Comparing Formula Strings after Row has been Inserted 3
Conditional Formating: MAX & MIN 3
Sorting question sort of 5
if true, if not nested if funcion 2
Condition based copy/paste of range 2
Re : Excel Data>Sort... Tracking of Cell Addresses Used in Formulae 1

Back
Top