Thread: how do I add round to a IF statement?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
  
Posts: 1,696
Default how do I add round to a IF statement?
=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