# If functions

Closed
Mattcwilhelm - Feb 1, 2010 at 07:01 PM
rizvisa1 Posts 4478 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 responses

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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?
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
venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
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
>=
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?