0 |
Subject: Quick Excel Question
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?
|
|
|
Post a reply to this message: (But first, how about checking out this sponsor?)
|