Ian Bell
asked on
Round an IF statement formula
Hi,
I would like a formula to round an if statement
Please refer to attached
Many thanks
Ian
round-if-statement.xlsx
I would like a formula to round an if statement
Please refer to attached
Many thanks
Ian
round-if-statement.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh this is amusing. Having just registered for EE and put a problem up I thought I'd browse Excel as a crack hand at that stuff. So looked at your .xls and the obvious answer was =ROUND(MIN(5,C3),0). A logically more sound way to deal with what is going on, but get to exactly the same answer so who cares!
What I didn't notice in my EE nouvettedom is the q is marked as answered! =INT(MIN(5,C3+0.5)) is another way to skin that cat...
What I didn't notice in my EE nouvettedom is the q is marked as answered! =INT(MIN(5,C3+0.5)) is another way to skin that cat...
ASKER
Skinning cats seems popular, everyone is at it. :)
Thanks for your contribution Vince.
Thanks for your contribution Vince.
ASKER
Thank you Saqib
Ian