formula please

[Gangadhar]

cell A2 is more than 385 "high" and cell A2 less than 185 "low" normal "yes mark"

 

[HighAndWilder]

cell A2 is more than 385 "high" and cell A2 less than 185 "low" normal "yes mark"

=IF(A2>385,"High",IF(A2<185,"Low","Yes Mark"))

 

[Fluff]

Hi & welcome to MrExcel.
Another option

=CHOOSE(SIGN(385-A2)+2,"High","Yes Mark","Low")

 

[Gangadhar]

=IF(A2>385,"High",IF(A2<185,"Low","Yes Mark"))

thank you very much

Hi & welcome to MrExcel.
Another option

=CHOOSE(SIGN(385-A2)+2,"High","Yes Mark","Low")

thank you somuch

 

[Gangadhar]

B6 and B7 formula please calculation image uploded please

 

[Fluff]

As this has nothing to do with your OP it needs to be a new thread & you will need to give a lot more information.

 

[Gangadhar]

Please

 

[Fluff]

As I said before, you need to start a new thread.