I am SOO new to excel, I need help, I have a starting number of 2,400,000, I need to find 90% of that number, how do you come up with the formula for this ?
Thanks !
I am SOO new to excel, I need help, I have a starting number of 2,400,000, I need to find 90% of that number, how do you come up with the formula for this ?
Thanks !
assuming that your 2,400,000 is in cell A1, and you want the answer in B1,2,400,000, I need to find 90%
put this in B1.
and then mew.Please Login or Register to view this content.
=IF(AND(OR(BLONDE,BRUNETTE,REDHEAD),OR(MY PLACE,HER PLACE),ME),BOW-CHICKA-BOW-WOW,ANOTHER NIGHT ON THE INTERNET)
A better practice than "hard coding" within formulae which makes your spreadsheet more flexible is done by separating the "constants" out into separate cells & having the result formula stand alone ie:
Cell A1 = "2,400,000"
Cell B1 = "0.9"
Cell C1 = "=A1*b1"
Now you can change A1 or B1 & watch the impact on the result. This also means that there are fewer chances of future errors in the spreadsheet if the percentage is ever meant to be changed because it is now clearly visible (rather than hidden within a formula which can be easy to overlook).
hth
Rob
Last edited by broro183; 01-24-2009 at 04:46 PM. Reason: typo
Rob Brockett
Kiwi in the UK
Always learning & the best way to learn is to experience...
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks