Author Topic: Excel help  (Read 6237 times)

0 Members and 1 Guest are viewing this topic.

Online Shay's Given Tim Flowers

  • General Member
  • Stephen f***ing Hawkinson
Re: Excel help
« Reply #50 on: Sunday 4 November 2018, 06:45:13 pm »
Cheers Dave and what if I wanted multiple would they follow sequentially like this?

So =if(C5="ps",65, "wcc",70 "")

so if cell C5 was PS then G5 would be 65 but if Cell C5 was WCC then G5 would be 70

Thanks for your help. I'm a complete excel noob.

Offline Dave

  • Administrator
Re: Excel help
« Reply #51 on: Sunday 4 November 2018, 06:54:26 pm »
Probably best with a table of possible return options, then use sumif instead.

Like this, assuming this starts from cell A1 and your target cell is C5:

A    1
B    2
C    3
D    4

In your result cell you'd put =sumif(A1:A4,C5,B1:B4).

So B would return 2, D would return 4 etc. Then you can sum the total of the results.

Offline Dave

  • Administrator
Re: Excel help
« Reply #52 on: Sunday 4 November 2018, 06:58:03 pm »