Nicki has attended:
Excel Dashboards for Business Intelligence course
IF function
Hello I have been using the IF function to show performance by an arrow with windings characters..
=IF(R3>Q3,CHAR(233),IF(R3<Q3,CHAR(234),CHAR(232)))
I am now trying to do the same with the sum of 3 cells compared with another 3 cells, but it shows as an error..
=IF(R4>Q4,CHAR(233),IF(R4<Q4,CHAR(234),CHAR(232)))
am I using the wrong function ??
RE: IF function
Hi Nicki,
Thank you for the forum question.
I copied your Ifs and put them in my workbook. I formatted the cells to Windings and everything worked fine.
Sorry I cannot tell you why you got the error.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: IF function
Hi Jens
Sorry I posted the same formula twice!
The second one involves comparing sums of cells and is the one that wont work :-( I am finding it confusing....
=IF(P4:R4>M4:O4,CHAR(233),IF(P4:R4<M4:O4,CHAR(234),CHAR(232)))
RE: IF function
Hi Nicki,
Try:
=IF(sum(P4:R4)>sum(M4:O4),CHAR(233),IF(sum(P4:R4<M4:O4),CHAR(234),CHAR(232)))
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: IF function
Yes Jens thank you!
=IF(SUM(P4:R4)>SUM(M4:O4),CHAR(233),IF(SUM(P4:R4)<SUM(M4:O4),CHAR(234),CHAR(232)))
RE: IF function
I am happy to help
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
