View Single Post
  #2   Report Post  
Poon Xiulok
 
Posts: n/a
Default

if(c1250,c125*2.75%+0.30,0)

"Chris" 写入消息新闻
...
I need to create a formula that can recognize when the cell is 0.

For instance: If C125 is Greater than 0 perform function as follows
(=c125*2.75%+0.30) if it is equal to 0 then results should be 0.

Can this be done? If so what is the function to perform this task?