|
| Posted by: Rendle
- [253571312] Thu, Apr 13, 2006, 15:24
Quick question. I have a column where I need to first do an if statement and then round it. The round statement is '=mround(P3,J3)' and the if statement is '=if(R3>S3,D3,P3' I am confused at how you would state that to get the values I need. Thanks in advance. |
| | | 1 | RecycledSpinalFluid
ID: 2211342315
Thu, Apr 13, 2006, 15:37
|
Think you just need to do this:
=Round(IF(R3>S3,D3,P3),J3)
|
|
| | | 2 | Rendle
Donor
ID: 014815714
Thu, Apr 13, 2006, 16:50
|
That worked but with MROUND instead of ROUND. Thanks alot for the help.
|
|
| | | 3 | RecycledSpinalFluid
Dude
ID: 204401122
Fri, Apr 14, 2006, 11:29
|
Glad it worked. BTW, what version of Excel are you using?
|
|
|
|