ExcelBanter - if function

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - if function (https://www.excelbanter.com/excel-discussion-misc-queries/143850-re-if-function.html)

if function

On May 23, 11:45 am, Barb Reinhardt
wrote:
What do you have so far?

" wrote:
i am taking an excel class and i am have a very hard time trying to
get an if function to work. I need that if the rounded cell is Y then
the cell with the decimal must round two places. I got the part if
the statement is null but I cant get the true statement. Please help.

- Hide quoted text -

- Show quoted text -

=IF(C28="Y" =ROUND(C30,2),C30)

Toppers

if function

Do you mean ...

=IF(C28="Y",ROUND(C30,2),C30)

" wrote:

On May 23, 11:45 am, Barb Reinhardt
wrote:
What do you have so far?

" wrote:
i am taking an excel class and i am have a very hard time trying to
get an if function to work. I need that if the rounded cell is Y then
the cell with the decimal must round two places. I got the part if
the statement is null but I cant get the true statement. Please help.

- Hide quoted text -

- Show quoted text -

=IF(C28="Y" =ROUND(C30,2),C30)

All times are GMT +1. The time now is 12:13 PM.