# 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.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

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

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…