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
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022  Feb 2, 2010 at 09:48 AM
Related:
 If functions
 Functions of spreadsheet  Guide
 When you wrote incorrect functions, what did you learn about spreadsheet data? ✓  Excel Forum
 Functions of wifi  Guide
 Multiple functions in one cell  Excel Forum
 How many if functions are available in excel  Guide
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
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
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Feb 2, 2010 at 04:20 AM
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
Posts
4479
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
767
Feb 2, 2010 at 09:48 AM
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).