KuSTaV
noice
+947|6771|Gold Coast
Greetings.

Just a quick question/query. I'm trying to make a spreadsheet of my allocated internet allowance (inb4lolaustralia) per day, and Ive got two columns containing megabytes used and megabytes allocated.
Ive found that I should be averaging roughly 804 megabytes per day, and I was wondering if there was some type of rule that I could put in that would tell me if I was above or below my allocated allowance without having to manually calculate it. Eg, if I subtract the number of megabytes used from the 804 (MB allocated) allowance and I get a negative, Id like that to show up as 'over' or something similar. Does such a thing exist/

Ive searched google, but the results aren't too promising.

Cheers

Last edited by KuSTaV (2010-01-02 23:38:49)

noice                                                                                                        https://static.bf2s.com/files/user/26774/awsmsanta.png
AussieReaper
( ͡° ͜ʖ ͡°)
+5,761|6412|what

Into one of the cells write

=rowA-robB

And you can change the true, false to display something else.

^sorry the above is written non technically.
https://i.imgur.com/maVpUMN.png
KuSTaV
noice
+947|6771|Gold Coast
How would I do that?

Im a bit of a huge noob when it comes to stuff like this.
noice                                                                                                        https://static.bf2s.com/files/user/26774/awsmsanta.png
AussieReaper
( ͡° ͜ʖ ͡°)
+5,761|6412|what

Use the If statement. Look it up in excels help menu and it will explain everything.

Plus gives an example.

So the results column you have the result of 50

Column A)
Row      2) 50


Formula Description (Result)
=IF(A2<=100,"Within budget","Over budget") If the number above is less than or equal to 100, then the formula displays "Within budget". Otherwise, the function displays "Over budget" (Within budget)
=IF(A2=100,SUM(B5:B15),"") If the number above is 100, then the range B5:B15 is calculated. Otherwise, empty text ("") is returned ()


hope that makes sense.

Last edited by AussieReaper (2010-01-02 23:53:09)

https://i.imgur.com/maVpUMN.png
KuSTaV
noice
+947|6771|Gold Coast
Aahahahahaha

Cheers bro. Thats wicked.
noice                                                                                                        https://static.bf2s.com/files/user/26774/awsmsanta.png

Board footer

Privacy Policy - © 2025 Jeff Minard