Previous Topic Next Topic

If Then

Closed
MM - 11 Sep 2009 à 20:13
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 - 12 Sep 2009 à 21:53
Hello,
I have four years of data by month (ex: Cell B1 - B12 are the calendar months, C2 - C12 are the $ amounts).
I need a formula that returns the month when the cost exceeds 95%.

Example
Cell A1 42.75 = 95% of known number

Cell B1 - B12 are the months and C1 - C12 are the $ amounts
Jan, Feb., Mar., etc
10, 15, 20, etc.

How do I get excel to return the month of March as the answer?

1 response

Réponse 1 / 1
venkat1926 Posts 1863 Registration date Sunday 14 June 2009 Status Contributor Last seen 7 August 2021 811
12 Sep 2009 à 21:53
"when the cost exceeds 95%. "
95% of what number

A1 42.5 is this known number of 95% of known number


again Mar is 20 this is not more than 95%of 42.5(that is 40.37) then how can be Mar returned.
what is meant by "returned"

please rephrase your question clearly

any how suppose your data is like this from a1 to C4


42.75 jan 10
feb 15
mar 20
apr 50
in D1 copy paste this formula
=IF(C1>=$A$1*0.95,B1,"")
hit enter key
copy D1 down
you will get apr in D4.

modify the formula to suit you