If functions
Closed
Mattcwilhelm

Feb 1, 2010 at 07:01 PM
rizvisa1
rizvisa1
 Posts
 4479
 Registration date
 Thursday January 28, 2010
 Status
 Contributor
 Last seen
 May 5, 2022
Related:
 If functions
 Functions of spreadsheet  Articles
 Functionality of wifi  Guide
 Function key stuck on  Guide
 Acer function keys not working  Guide
 Mutator functions  Guide
5 replies
venkat1926
Feb 1, 2010 at 08:00 PM
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
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
is this what you want?
=if(A1=40,A1*B1,"")
is this what you want?
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
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
venkat1926
Feb 2, 2010 at 04:20 AM
 Posts
 1864
 Registration date
 Sunday June 14, 2009
 Status
 Contributor
 Last seen
 August 7, 2021
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 V5I 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
>=
any how in your case suppose
suppose AE4=35
V4=100(is it V4 or V5I 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
>=
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.
Didn't find the answer you are looking for?
Ask a question
rizvisa1
Feb 2, 2010 at 09:48 AM
 Posts
 4479
 Registration date
 Thursday January 28, 2010
 Status
 Contributor
 Last seen
 May 5, 2022
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).
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).