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

Hands-on: Samsung Galaxy S8 review

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

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too