Nested IF Statements not working

[VisionSmart]

Hello all,
Using Excel 2010 Pro - Trying to set IF statements to record weather against Kwh output from my Solar system
The attached is my effort – but it does not work.
Help please.

[Zenarte]

Hello Vision, to add attachments here you must click at the "Go Advanced" button at the right bottom of the screen, then scroll down a little until you find in the "Additional Options" segment the "Manage Attachments" menu. From there, you can select the files that you want to upload.

[VisionSmart]

Thankyou

2nd attempt to attach file

[Zenarte]

Hey there mate, I've made a few adjustments on it, I hope that it can help you out somehow. Cheers,


--

Zenarte

[Zenarte]

PS. Just a small correction, at the end of the formula, you might as well correct with that bold part. Otherwise, if the weather is 5º, it'll only display "-" instead

=IF(C5>20;G$8;IF(AND(C5<=20;C5>15);G$7;IF(AND(C5<=15;C5>5);G$6;IF(C5<=5;G$5;"-"))))

[VisionSmart]

Terrific Zenarte. Using the AND statement was the part I could not understand.
THankyou