Ignore a cell used in a formula if it contains a negative value

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

Guest

I am trying to create a simple formula...=(F40*F28)+F30

F30 is a calculated cell. Sometimes it may contain a negative value. When
F30 does contain a negative value I want the formula I am trying to create to
ignor it or use a zero.

Thanks for your help,

Donald Thomas
 

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

Using cell text as a Sheetname in a formula 12
How to avoid #DIV/0, I AM USING =AVERAGE(IF(F30:F69=3,O30:O69,"0") 5
right formula? 2
calculate formula if cell value is positive, show 0 if negative 3
ignoring negative numbers 4
Negative percentage in data verification dropdown list? 2
Sorting by Color in Excel 2003 5
Formula to calculate % using negative values 3

Back
Top