Thread: how do I add round to a IF statement?
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
  
Posts: 2,059
Default how do I add round to a IF statement?
"Kelly Ditsworth" <Kelly wrote:
I have the following formula and I want to round the same cell. Is this
possible?
=IF(C8=0,C8*J8,J8)

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

The IF() example does make sense as written. But I presume it is meant to
be a paradigm, not actual functionality.

Reply With QuoteReply With Quote