Using If function

[malesela]

Hi. I have three columns A1,A2&A3. I want A3 to display "Achieved", "Not achieved" or " ". A3 must reflect "Achieved" if cell A1 is greater than A2. "Not achieved" if less and "blank" if column A1 is blank. Thanks in advance.

[Syrkrasi]

Try This (nested If Statement)

=IF(OR(A1="",A2=""),"",IF(A1>A2,"Achieved",IF(A1<A2,"Not Achieved","")))

[kev_]

What happens if A1 = A2?
(Formula below returns "not achieved" with that scenario)

IF(A1="","",IF(A2="","",IF(A1>A2,"Achieved",Not Achieved")))
Edit
Should be:
IF(A1="","",IF(A1>A2,"Achieved",Not Achieved"))

[naeeim07]

TRY EITHER ONE

IF(A1="","",IF(A1>A2,"Achieved","Not Achieved"))

OR USE

IFERROR(IF(A1="","",IF(A1>A2,"Achieved","Not Achieved")),"Not Achieved")

[FDibbins]

Hi. I have three columns A1,A2&A3.

actually, thats three rows, not columns Rows go down, columns go agross

I want A3 to display "Achieved", "Not achieved" or " ". A3 must reflect "Achieved" if cell A1 is greater than A2. "Not achieved" if less and "blank" if column A1 is blank. Thanks in advance.

=if(A3="","",if(A1>A2,Achieved","Not Achieved"))

[malesela]

Thanks Kev. Your formula assisted me a lot. This is how I edited it"=IF(OR(A8="",B8=""),"",IF(B8>=A8,"Achieved",IF(B8<A8,"Not Achieved","")))" and its given me the results I want.

[kev_]

@Syrkrasi
Your post most closely resembles the solution

How about marking the thread as solved @malesala ? (Thread tools @ top of thread)