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
805
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
805
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
769
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