View Single Post
  #2  
Old July 20th, 2004, 07:58 PM
Jason Morin
external usenet poster
 
Posts: n/a
Default "and" "or" in formulas

=IF(OR(B17=0,C17=0),"",C17/B17)

HTH
Jason
Atlanta, GA

-----Original Message-----
I'm trying to write a formula to calculate the price of

an item as
follows:

=if(+b17=0) and or (+c17=0)," ",+c17/b17)

thanks for your help


---
Message posted from http://www.ExcelForum.com/

.