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

  toni b 00:41 03 Nov 2003
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 2003

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 2003

Thank you very much

TONI

  Cesar 09:49 03 Nov 2003

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.

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone