IF, and, or statements combined

  • Thread starter Thread starter lite
  • Start date Start date
L

lite

I have this formula where both rows is zero, but I do not want the error
Div#/0 or #value instead I want to display a zero.
I have:
IF(a7=0,0,100*(a7/a8))
IF(a8=0,0,100*(a7/a8))
Now I want to combine both to use if a7 or a8 are equal to zero, then give a
zero. otherwise give me the value ( which in some cases is a positive value
or percent)
any ideas???
 

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

Average last seven if not zero 5
Cell Background Color 1
New and exciting things 3
Date Time Question 1
"IF" help 2
Date Time Question 1
SUMIFS Issue 5
Finding last cell with a value and then adding to another 2

Back
Top