# 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

OnePlus 5T review: Hands-on

Illustrator Andrés Lozano on his improv line work, brazen use of colours & hand sketching

iPhone X review

Comment envoyer gratuitement des gros fichiers ?