Combining If Statment (Date) with ROUND function

[brandon12]

I am attempting to write a formula to assist with quality control during a payroll process (less manual manipulation). I would like a formula that pays an employee a specific amount (let's say $5,000 + 3%) until a specific date (let's say 11/14/2018). Once that date has past, I would like the employee to only be paid the $5,000.

What I have so far (which is obviously inaccurate as there are errors) is:

=IF(TODAY < DATE(2018,11,14),round(5000*1.03,2))

However, I believe I need to somehow declare an else portion of this formula for when the DATE has past and the 3% should not longer be paid.

Is this possible? Ideas?

 

[BGY23]

You'll need an if statement if you're using a formual to do it;

Assume your date is in G12 then [TABLE="width: 184"]
<colgroup><col width="245" style="width: 184pt; mso-width-source: userset; mso-width-alt: 7840;"> <tbody>[TR]
[TD="width: 245, bgcolor: transparent"]'=IF(TODAY(>G12,5000,5000*1.03)

To make it mor se friedlyyou could hav the amount in a different cell and reference that.


[/TD]
[/TR]
</tbody>[/TABLE]

 

[BGY23]

[TABLE="width: 287"]
<colgroup><col width="383" style="width: 287pt; mso-width-source: userset; mso-width-alt: 12256;"> <tbody>[TR]
[TD="width: 383, bgcolor: transparent"]=IF(TODAY()>G12,5000,5000*1.03)
[/TD]
[/TR]
</tbody>[/TABLE]
sorry I missed the ) after the ( after today

 

[brandon12]

Is there not a way to eliminate the use of an outside cell.

You'll need an if statement if you're using a formual to do it;

Assume your date is in G12 then [TABLE="width: 184"]
<tbody>[TR]
[TD="width: 245, bgcolor: transparent"]'=IF(TODAY(>G12,5000,5000*1.03)

To make it mor se friedlyyou could hav the amount in a different cell and reference that.

[/TD]
[/TR]
</tbody>[/TABLE]

 

[brandon12]

Disregard... I utilized the formula you provided and inserted the specific date instead and it seems to work great:

IF(TODAY()>DATE(2018,11,14),5000,5000*1.03)

Thanks!

Is there not a way to eliminate the use of an outside cell.

 

[brandon12]

Is there anyway to include the ROUND function into this IF statement?

Is there not a way to eliminate the use of an outside cell.

 

[BGY23]

Amend brandons formula........5000,Round(5000*1.03,2))

 

[Scott Huish]

5000*1.03 is still a whole number. No need to round.

=IF(TODAY()<DATE(2018,11,14),5150,5000)

However, today is November 15, 2018 and the first part of the IF will never be true at this point. So perhaps you want to compare to a different cell maybe ??

 

[brandon12]

The $5,000 is an arbitrary number and my scenario will more often than not encompass non-whole numbers. The date 2018-11-14 was just for checks and balances. Since that date is in the past the employee should be paid only the $5,000 which the formula is calculating accurately.

Here is a more accurate picture of how I'm using it with a future date inserted:

=IF(TODAY() < DATE(2019,1,31),ROUND(6251.37*1.03,2),6251.37)<date(2019,1,31),round(6251.37*1.03,2),6251.37)


Thanks!

5000*1.03 is still a whole number. No need to round.

=IF(TODAY()<date(2018,11,14),5150,5000)

However, today is November 15, 2018 and the first part of the IF will never be true at this point. So perhaps you want to compare to a different cell maybe ??

</date(2018,11,14),5150,5000)
</date(2019,1,31),round(6251.37*1.03,2),6251.37)