Returning a '0' if no data

[tintostu]

I'm putting together a sheet, that calculates profit margin, however I'm if there is not an input on qty i get the DIV/0! error.

The formula is as shown, =sum(I7/(H7/1.2)*100%) the '0' input is linked into the H7 cell.

All I want it to return is 0.00% if there is a '0' in cell C7

Thanks for your help in advance

Stuart

 

[Darren Bartrup]

This should work:

=if(H7=0,0,SUM(I7/(H7/1.2)*100%))

 

[Aladin Akyurek]

I'm putting together a sheet, that calculates profit margin, however I'm if there is not an input on qty i get the DIV/0! error.

The formula is as shown, =sum(I7/(H7/1.2)*100%) the '0' input is linked into the H7 cell.

All I want it to return is 0.00% if there is a '0' in cell C7

Thanks for your help in advance

Stuart

=IF(N(H7),I7/(H7/1.2),0)

Format the formula cell as percentage.

 

[Darren Bartrup]

Never thought of doing it that way Aladin. Still learning after all these years.

 

[Aladin Akyurek]

Never thought of doing it that way Aladin. Still learning after all these years.

It's an interesting function to have, indeed.