# Using ROUND and IF

1. ## Using ROUND and IF

This is my formula: =IF(AND(\$C3<=1.875,\$C3>1.75),\$D3*F3,"")

The cell is blank if the logical test is FALSE. How can I get the \$D3*F3 equation to round to nearest 10 and still have a blank cell if the logical test is FALSE.

I tried this equation: =ROUND(IF(AND(\$C3<=1.75,\$C3>1.625),\$D3*G3,""),-1)
which does round to the nearest 10 if the logical test is TRUE: but will not leave the cell blank if the logical test is FALSE.

2. ## Re: Using ROUND and IF

Put the round INSIDE the IF, instead of the IF inside the Round..

=IF(AND(\$C3<=1.875,\$C3>1.75),ROUND(\$D3*F3,-1),"")

3. ## Re: Using ROUND and IF

Thank you, I should have caught that.

4. ## Re: Using ROUND and IF

You're welcome.

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1