If

[andspenka]

I'm having problems with the IF function, I hope someone can tell me what's wrong and point me in the right direction.



I'm trying to make a sheet to help with Caravans and License Restrictions, my cells are as follows.

In cell F21 I have the following:

=IF(D12<D21,"OK","B&E Required")

Cell D21 has the following in it:

=IF(B21<1997,"7500", "3500")

I think the reason it's not working is because the cell I'm referencing has the values inputted by another IF function. I have changed cell D21 to D22 and entered the values manually and it works how it should.

Where am I going wrong?

Cheers in advance

[jeffreybrown]

Hello & Welcome to the Forum,

Since you are comparing the values of numbers, remove the quotes from the number in your D21 formula.

=IF(B21<1997,7500,3500)

[andspenka]

That's great thanks,

I had a feeling it would be something simple, didn't realise it would be that simple

[jeffreybrown]

You are very welcome. Glad you have a workable solution now.