View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Trishcuria Trishcuria is offline
external usenet poster
 
Posts: 2
Default function with IF, OR, & AND

I have the following as an example

A B C

1 0 5
2 0 0

I need a formua which will return in column C the following:

If a & b are both equal to zero, then "" (blank), but if a is equal to 0 and
b is greather than zero, then C needs to equal 125%.

I cant seem to be able to combine both of these elements into one formual