https://www.youtube.com/watch?v=ce76NYo0Na4
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titl
Hi Vinod,
Use the below formula.
=AVERAGE(MIN(G3:G5),LARGE(G3:G5,2))
Regards
Ashish Bhalara
On Fri, Jun 24, 2016 at 12:57 PM, Vinod Kumar wrote:
> Good Afternoon,
>
> Please help, how to calculate the average price between the lowest and
> second lowest price, when there is 5 different price
Good Afternoon,
Please help, how to calculate the average price between the lowest and
second lowest price, when there is 5 different price for one item.
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum
Dear Smitha,
You can try this accordingly
If condition1 = true and condition2 = true and condition3 = true then
'Your code here
else
'Your code here
end if
Regards,
Lalit Mohan
https://www.facebook.com/buzinesstransformation
On Wed, May 16, 2012 at 4:44 PM, Nare
Hi Smitha,
Can you please send sample file. So that we can help you. In
If function you can add any function.
Thanks,
Naresh V
On Wed, May 16, 2012 at 7:11 AM, Smitha S R wrote:
> How can we add so many conditions in IF function?
>
> --
> FORUM RULES (986+ members already B
How can we add so many conditions in IF function?
--
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 will not get
quick attention or may not
You don't format the value using TEXT function in this case. Use format
cells to format. Check the attachment.
Regards,
Sam Mathai Chacko
On Tue, Feb 7, 2012 at 8:49 PM, hilary lomotey wrote:
> Hello Experts,
>
> i have a data, i want the data to read " decrease" when the % change for
> the se
Hello Experts,
i have a data, i want the data to read " decrease" when the % change for
the selected year is -ve eg (7.9%) otherwise to read "positive", i have
used the formula ="This represents a % "&IF(P7<0,"decrease","increase"),
but it doesnt change when the sign changes. kindly assist. thank
Dear Vebhav,
Please see attachment with solution.
Thank,s
Noorain
On Thu, Aug 26, 2010 at 9:39 AM, vebhav jain wrote:
> Hi All,
>
> Please find the attachment, where i finding the difficulty to get the right
> solution.I have narrated the problem clearly in the excel file.
>
> Thankyou,
> Vebhav
Dear Vebhav,
Your problem is solved, see the attachment.
Kalyan
On Thu, Aug 26, 2010 at 9:39 AM, vebhav jain wrote:
> Hi All,
>
> Please find the attachment, where i finding the difficulty to get the right
> solution.I have narrated the problem clearly in the excel file.
>
> Thankyou,
> Vebhav
Hi All,
Please find the attachment, where i finding the difficulty to get the right
solution.I have narrated the problem clearly in the excel file.
Thankyou,
Vebhav Jain
--
--
Some important links for excel users:
1
Ok, can someone help me out? I am trying to create formula that is
going to round my numbers to x.47 or x.97.
A1=$9.99
B1=75%
C1=A1-B1=$2.49
So what I am trying to do is to take discount from price and if it
ends x.49 I would like to round it x.47 and if it ends x.99 I would
like to round it to x
12 matches
Mail list logo
