# round formula

#### sburkhar

##### Active Member
Can someone round this formula to 4 decimal points please?

IF(B7<>"Wire",IF(OR(F7<0),"ERROR",F7),0)

### Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).
Can someone round this formula to 4 decimal points please?

IF(B7<>"Wire",IF(OR(F7<0),"ERROR",ROUND(F7,4)),0)
See if the above change works for you or not...

That's what I kept trying and it wouldn't work, but now that YOU suggested it, it works. Hmmmmm.......
thanks!

There's also no need for the OR with only 1 condition:

IF(B7<>"Wire",IF(F7<0,"ERROR",ROUND(F7,4)),0)

ok - thanks! I'll take it out

Replies
3
Views
167
Replies
3
Views
99
Replies
4
Views
206
Replies
16
Views
328
Replies
4
Views
373

Threads
1,206,921
Messages
6,075,589
Members
446,147
Latest member
homedecortips

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back