If Then

Closed
MM - Sep 11, 2009 at 08:13 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Sep 12, 2009 at 09:53 PM
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 reply

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Sep 12, 2009 at 09:53 PM
"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
0