2012 4:53
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: IF Function
Hello Smitha,
Instead of IF , if you are using 2007 version you can use SUMIFS , if you
are on 2003 Sumproduct can help you.
On Wednesday, May 16, 2012 2:11:28 PM UTC+3, Smitha S R wrote:
How can we
Hello Smitha,
Instead of IF , if you are using 2007 version you can use SUMIFS , if you
are on 2003 Sumproduct can help you.
On Wednesday, May 16, 2012 2:11:28 PM UTC+3, Smitha S R wrote:
> How can we add so many conditions in IF function?
>
--
FORUM RULES (986+ members already BANNED f
Thanks Kris, wow, this index formula makes my work really easy, thanks
boss, u r great,
On Tue, Feb 7, 2012 at 4:27 PM, Kris wrote:
> Hi
>
> You are welcome !!
>
> BTW, you could replace the P7 formula with
>
> =INDEX(I4:I26,A1)
>
> Kris
>
> --
> FORUM RULES (986+ members already BANNED for viol
Hi
You are welcome !!
BTW, you could replace the P7 formula with
=INDEX(I4:I26,A1)
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
Thanks Kris, very helpful
On Tue, Feb 7, 2012 at 4:13 PM, Kris wrote:
> Hi,
>
> Replace your Col I formula. In I4 and copied down,
>
> =IFERROR(C4/C3-1,"N/A")
>
> custom format the cell as *0.00%;(0.00%)*
> *
> *
> Kris
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use
Hi,
Replace your Col I formula. In I4 and copied down,
=IFERROR(C4/C3-1,"N/A")
custom format the cell as *0.00%;(0.00%)*
*
*
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formul
Hi David,
Thanks for your feedback and evaluation. I've corrected and posted the
solution, please check this link again to see the changes:
http://www.excelitems.com/2009/03/ceiling-and-floor-function.html
For more tips, tricks, downloads and problem solutions: visit -->
http://www.excelitems.c
Ashish,
Thank you so much for responding but let me ask you this. Can formula be
twiked that everything between x.51 and x.99 in C1 is rounded to x.97 and
everything between x.01 to x.49 in C1 is rounded to x.47.
Your example shows:
9.99 75% 2.50 2.47 25.99 60% 10.40 10.97 29.99 30% 20.99 20.
Hi DM,
I've posted your solution, please check this link:
http://www.excelitems.com/2009/03/ceiling-and-floor-function.html
For more tips, tricks, downloads and proble
