Ecxel query how do I.......write formula........

  toni b 00:41 03 Nov 03
Locked

I am trying to use excel what I am trying to do is IF I have...(Number)..in column C8 and if the number is greater thank K27 i would like the word "HIGH" to be seen in column P8 ...and if C8 is lower than K27 then the word "LOW" in coloum P8 ......what formula must i right to achive this I have very rarely used excel

  Peverelli 01:10 03 Nov 03

One formula is:

=IF(C8>K27,"High",IF(C8<K27,"Low",""))

If you wanted to put "Equal" into P8 should C8 and K27 be the same then it's:

=IF(C8>K27,"High",IF(C8<K27,"Low","Equal"))

  toni b 01:16 03 Nov 03

Thank you very much

TONI

  Cesar 09:49 03 Nov 03

There is plenty of help online for Excel users this is just one, click here good luck.

This thread is now locked and can not be replied to.

What is Amazon Go and will it come to the UK? The store without checkouts or queues

1995-2015: How technology has changed the world in 20 years

Why ecommerce hasn't taken off on social media

Super Mario Run preview | Hands-on first impressions of Super Mario Run: Mario's iPhone & iPad…