he places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
From: Dhartikumar Sahu
To: excel-macros@googlegroups.com
Sent: Thu, October 4, 2012 2:14:03 AM
Subject: $$
Hi,
I didn't get what exactly you want. But attached solutin file as per my
understanding.
You cannot have more than 7 nested If conditions so I have used different
formula.
Formula:
=IF(A2>50, IF(MROUND(A2, 5)wrote:
> hi Group
>
> Can u please help me out in this problem. I have an query of
hi Group
Can u please help me out in this problem. I have an query of Multiple if
conditions
if % Column true then result will be shown in solution.
% if Solution 37 >50 – 55% 0.55 50.3 >55 – 60% 0.6 50.09 >60 – 65%
0.65 62.43 >65 – 70% 0.7 68.39 >70 – 75% 0.75 30.43 >75 – 80% 0.8 50