THIS SITE HAS BEEN ARCHIVED AND CLOSED.

Please join the conversation over on our new forums »

If you really want to read this, try using The Internet Archive.

Boards

Excel question (no. 57863)

crisps [Edit] [Delete] 16:24, 26 November '14

So, I've got this cell right, B23.

In this cell I want to put an IF function that says if F23 equals X then B23 is £600, if F23 equals Y then B23 is £1000, if F23 equals Z then B23 is £1300.

I thought I knew how to do this shit, but it appears I don't. Bet some of you twats do.

Help a brother out.