Thread: how do I add round to a IF statement?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kelly Ditsworth[_2_] Kelly Ditsworth[_2_] is offline
external usenet poster
  
Posts: 2
Default how do I add round to a IF statement?
Sean: It worked like a champ. I been fighting this for quite awhile.
thanks so much!

"Sean Timmons" wrote:

=IF(C8=0,ROUND(C8*J8,0),round(J8,0))

"Kelly Ditsworth" wrote:

I have the following formula and I want to round the same cell. Is this
possible?
=IF(C8=0,C8*J8,J8)
Reply With QuoteReply With Quote