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)