help, i wan t more than one IF statement

S

slickgemnem

Here is my problem, i have four columns and each has an amount in i
under headings rate a, rate b, rate c, and rate d. in the fifth colum
i want to display the cheapest in the form of that particular colum
heading.

Rate A cost Rate B cost Rate C Cost Rate D cost Cheapest
£24.70 £31.55 £29.49 £36.30 ????


why can i not have two if statements :

=IF(B8>C8,"Rate A","Rate B",IF(D8>E8,"rate c","rate D"))


help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

help, i want more than one IF statement 2
quary help 1
Help with a really big IF statement 9
Help - Not sure where I should start 7
Complicated If Statement - I Think! 5
IF and AND/OR 1
If Statement 2
Multiple criteria with multiple results in one cell 4

Top