Excel help - IF formula

[jerzdawg]

Another Excel question for the experts:

Cell K11 will ask for a numeric value, if this value is greater than 26 I would like to insert a custom message in cell A30.

Thanks in advance!

Edit - going to complicate things

If possible I'd like it also to verify another cell as well, this would be a 2 digit code. so...

A8 - if it equals these four codes (AA, BB, CC, DD) then check to see if K11 is over 26 if both are true, insert custom message into A30...

[+primortal Subscriber²]

In cell A30 use this formula =IF(K11>26,"Hi","")

[Haggis Veteran]

awww that was an easy one :(

[jerzdawg]

In cell A30 use this formula =IF(K11>26,"Hi","")

thanks.. any chance you can help me with my edit above?

[+primortal Subscriber²]

Easy,

=IF(AND(OR(A8="AA",A8="BB",A8="CC",A8="DD"),AK11>26),"Hi","")

[jerzdawg]

awww that was an easy one :(

ive complicated things above .. :D

sorry he beat you again!!

[Haggis Veteran]

:( sucks lol