LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ty Ty is offline
external usenet poster
 
Posts: 72
Default Less Excel more Math

This post is less about Excel and more about Math and percentages. I
have some numbers and trying to think. It's like I need some NZT like
the movie Limitless if you are reading this post and saw the movie.
Anyways...

I need 3% of a total number. Then I need to check to see if the
customer actually has 3 % in the actual number in another column(E2).
I have 120(F2) and I did a =+F2*0.03 which equals 4(in G2). Now the
customer just so happen to have 4 in column E2. So, now I need to
check to see if they are at 3%. So, I did a =+E2/F2(in i2). I have
that the customer is right at 3%(in i2).

Here is another example using the logic up top.

715(in F3) 21(in G3) and my answer for the percentage is 3% (in i3)

Is my logic ok?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Math functions in Excel Farhad Excel Discussion (Misc queries) 2 February 19th 07 04:16 PM
Excel can't do basic math?! Steven Sinclair Excel Discussion (Misc queries) 18 August 21st 06 09:42 PM
How do I ? math/excel question Madduck Excel Discussion (Misc queries) 3 July 26th 06 05:41 AM
More math than excel, but a fun problem S Davis Excel Worksheet Functions 4 July 6th 06 10:04 PM
Excel Math formulas [email protected] Excel Discussion (Misc queries) 2 November 16th 05 03:33 AM


All times are GMT +1. The time now is 06:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"