ExcelBanter - View Single Post

Poon Xiulok wrote:
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?

Just in case negative values are possible
IF(C125<0,C125*2.75%+0.30,0)

best wishes
--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address