I want to make formulas for conditions :that if ratio of two(I4,J4 for example) is <0,2 than report<0,2, otherwise take the result into account, but make sum rounded to one decimal place.

I'm not sure what you mean by " but make sum rounded to one decimal place"since you don't have a SUM function mentioned anywhere in your question.Are you looking for something like this?

=IF(I4/J4<0.2, "<0.2", ROUND(I4/J4,1))

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Sorry,my mistake in posting.

Yes, something like that.

I would like to sum from I1 to I8 all the results that are>0,2 and round them to one decimal place.(but with one condition in excell)

Thank you in advance,

tiru

re: but with one condition in excellWhat does

one conditionmean?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

I ve sold it out in the meantime,

thanks anyway

Ask Your Question

Weekly Poll