Forum Discussion
Help to create a formula
Hi I am trying to create a formula that tells me that I need to change the rate of pay for someone when they reach a new age category. I have a column and formula to create the exact age (17years, 3 ...
You may apply conditional formatting rule with the formula which compares values of Minimum Wage Rate with value in Current Rate
Hi, thank you for your reply, which formula?SergeiBaklan
The formatting is helpful thank you but what about the initial formula?
I Require the following
If (CELL) is equal to or greater than 25 then £8.21
IF (CELL) is less than 25 or equal to or great than 21 then £7.70
IF (CELL) is less than 21 or equal to or greater than 18 then £6.15
IF (CELL) is less than 18 then £4.35Do you see what I mean? Are you able to help me create that formula?
The (CELL) i refer too is an exact age formula as follows:
=DATEDIF(C4,TODAY(),"Y") & " Years, " & DATEDIF(C4,TODAY(),"YM") & " Months, " & DATEDIF(C4,TODAY(),"MD") & " Days"
