Writing a formula

  • Thread starter Thread starter changetires
  • Start date Start date
C

changetires

I want to write this as a formula: 1 minus F6 divided by F6 plus Z6 plu
AA6, but only if AA6 is less than zer
 
=if(aa6<0,(1-f6)/(f6+aa6),0)

This will return 0 if aa6 is not less than 0. Replace the 0 with whatever
you want if aa6 is not less than 0.

Shaun
 

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

writing a formula 1
leftmost number value 1
Need formula to I have too many nested level 2
I need cell formula help 3
Referencing a cells value 3
Cause formulae totals to reflect negative and positive amount inpu 7
Excel 2007 formula help 1
AddIn not working right 2

Back
Top