If functions

Closed
Mattcwilhelm - Feb 1, 2010 at 07:01 PM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Feb 2, 2010 at 09:48 AM
Hello,
I am trying to get an if function to work so that when a certain cell is less than equal to 40 it will multiply that cell by another cell to give me my total wage dollars before overtime. If anyone out there can help I would very much appreciate it.

Matt Wilhelm

5 replies

venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 1, 2010 at 08:00 PM
suppose your first cell is A1 and second cells is B1 then in some other cells try this formula

=if(A1=40,A1*B1,"")

is this what you want?
0
I tried that and it didn't work, so it must not be what I am after. Here are the cells that I am working with and what they mean. AE4 is my total hours including overtime. I want the total hours of 40 hours and lower to be multiplied by V5 which is their wage. I guess the main question is this possible?
I was able to figure out how to get my overtime calculated with all the hours that above 40 multiplied by v6 but for some reason can't get it to do the same for 40 hours and below.
I appreciate the help!

Matt
0
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 810
Feb 2, 2010 at 04:20 AM
sorry I have not seen "leass than " equal to 40

any how in your case suppose

suppose AE4=35
V4=100(is it V4 or V5--I expect it to be V4)

in any cell the formula

if (AE4<=40,AE4*V4,"")

so you will get 3500 because AE4 is less than equal to 40

is this ok
if it is really V5 then change the formula into

if(AE4<=40,AE4*V5,"")

I suppose you do not know the symbol for less than or equal to . it is
<=

if it more than or equal to then it is
>=
0
It was closer, This is what I thought it was at first to but all I get is FALSE in the box (if i leave the "" at the end I just get a blank box). I appreciate the help. It may be that this formula isn't usable in excel.
0

Didn't find the answer you are looking for?

Ask a question
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 767
Feb 2, 2010 at 09:48 AM
The blank you are getting is what the formula says

if (AE4<=40,AE4*V4,"")

Above is saying that if AE4 is less than or equal to 40 then multiply AE4 by V4
and if AE4 is greater than 40 then do nothing but put a blank there.

Just change the 2nd part of If to your likening (when AE4 is more than 40).
0