round and if excel function

May 21, 2012 at 12:09:20
Specs: Windows XP
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.

See More: round and if excel function

Report •

#1
May 21, 2012 at 13:49:49
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.


Report •

#2
May 22, 2012 at 14:01:01
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

Report •

#3
May 22, 2012 at 16:16:02
re: but with one condition in excell

What does one condition mean?

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


Report •

Related Solutions

#4
May 23, 2012 at 09:41:28
I ve sold it out in the meantime,
thanks anyway

Report •

Ask Question