Hi,
Please see the corrected formula.
=ROUND(IF(B4>=500000,500000*0.1),0)
Regards,
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "Him Prasad Gautam" <drishtibac...@gmail.com>
Sent: Saturday, March 21, 2015 6:06 AM
To: "AccessIndia: a list for discussing accessibility and issues
concerningthe disabled." <accessindia@accessindia.org.in>
Subject: Re: [AI] Excel question.
hi, Perhaps the first formula at b5 is wrong.
It should be,
round(if(b4<500000, b4, 500000)*1,0)
On 3/21/15, Mukesh Baviskar <mukeshbaviskar....@gmail.com> wrote:
Hi Giri Prasad,
For 10% in b5:
=ROUND(B4*0.1,0)
For 20% in b6:
=ROUND(IF(B4>500000,B4-500000)*0.2,0)
Hope this will solve your problem.
Regards,
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "Giri Prasad" <mgiriprasadma...@gmail.com>
Sent: Friday, March 20, 2015 7:13 PM
To: "AccessIndia: a list for discussing accessibility and issues
concerningthe disabled." <accessindia@accessindia.org.in>
Subject: Re: [AI] Excel question.
Dear Gautam and Mukesh,
I require a formula that suits my needs.
Suppose B4 contains the value 700000 that is 7 lakhs, I want 10% of B4
to be displayed in B5. But here is a condition that upto 500000 its
10%. For the remaining value its 20%. This 20% should be in the cell
B6. Hope you understood my point clearly.
Kindly help me in this conditioning formula.
Thanks in anticipation.
On 20/03/2015, Surya Prakash Sharma <spsharma.gc...@gmail.com> wrote:
Hello,
thanks for the support. I was asking for the third option you
mentioned and as I have mentioned earlier that formula suggested by
Mukesh does the job. thanks again.
On 3/18/15, Him Prasad Gautam <drishtibac...@gmail.com> wrote:
Though there is no trick; but there are different ways of percentage
expression. The formula differs as per format.
My key question is not yet replied.
Do you need the percentage sign automatically be written when the
value is calculated or you need just a value?
For example:
if the value is say 13 percentage. then;
what type of expression do you want?
a) 13.00% i.e the value with decimal figure and with automatically
generated percentage sign.
b) 13% i.e the value without decimal figure but with automatically
generated percentage sign.
c just 13 i.e the value without decimal figure and without the
percentage
sign.
The given formula belongs to the last format option.
On 3/18/15, Surya Prakash Sharma <spsharma.gc...@gmail.com> wrote:
Hello,
thanks to both of you.
to Him Prasad Gautam:
yes I want the figure equal to ten percent of the sum of b5
and c5 at d5 and the formula mentioned by Mukesh worked for that.
any
other trick if available is also requested.
On 3/17/15, Mukesh Baviskar <mukeshbaviskar....@gmail.com> wrote:
Hi,
Please try this formula:
in cell d5
=ROUND(SUM(B5,C5)*0.1,0)
Regards,
Mukesh Baviskar
Mobile: 9403161157
--------------------------------------------------
From: "Surya Prakash Sharma" <spsharma.gc...@gmail.com>
Sent: Tuesday, March 17, 2015 5:14 PM
To: "accessindia" <accessindia@accessindia.org.in>
Subject: [AI] Excel question.
Hello Accessindians, greetings of the day.
my query is: how to achieve rounded 10% of B5 + C5 in cell D5.
--
S. P. Sharma
Lecturer, Political Science
Govt. College Kaladera
Jaipur
Register at the dedicated AccessIndia list for discussing
accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other
changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the
thinking
of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on
the
mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing
accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other
changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the
thinking
of
the
person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
--
S. P. Sharma
Lecturer, Political Science
Govt. College Kaladera
Jaipur
Register at the dedicated AccessIndia list for discussing
accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking
of
the
person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
--
Him Prasad Gautam
Kathmandu, Nepal
Register at the dedicated AccessIndia list for discussing
accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking
of
the
person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
--
S. P. Sharma
Lecturer, Political Science
Govt. College Kaladera
Jaipur
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking
of
the
person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
--
WITH REGARDS
GIRIPRASAD
MOBILE 924710000 / 9441133367
SKYPE giriprasad.maddina
"Our greatest glory consists not in never falling,
but in rising every time we fall."
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility
of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the
mails
sent through this mailing list..
--
Him Prasad Gautam
Kathmandu, Nepal
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes,
please visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of
the person sending the mail and AI in no way relates itself to its
veracity;
2. AI cannot be held liable for any commission/omission based on the mails
sent through this mailing list..
Register at the dedicated AccessIndia list for discussing accessibility of
mobile phones / Tabs on:
http://mail.accessindia.org.in/mailman/listinfo/mobile.accessindia_accessindia.org.in
Search for old postings at:
http://www.mail-archive.com/accessindia@accessindia.org.in/
To unsubscribe send a message to
accessindia-requ...@accessindia.org.in
with the subject unsubscribe.
To change your subscription to digest mode or make any other changes, please
visit the list home page at
http://accessindia.org.in/mailman/listinfo/accessindia_accessindia.org.in
Disclaimer:
1. Contents of the mails, factual, or otherwise, reflect the thinking of the
person sending the mail and AI in no way relates itself to its veracity;
2. AI cannot be held liable for any commission/omission based on the mails sent
through this mailing list..
