# 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

#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 excellWhat 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 •