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

Do you think manufacturers should do more to reduce phone and tablet usage among kids?

Discuss in The Lounge

Poll History