Thread: [Solved] If
View Single Post
 
Old 02-18-2017, 01:50 PM
andspenka andspenka is offline Windows 10 Office 2016
Novice
 
Join Date: Feb 2017
Posts: 2
andspenka is on a distinguished road
Default If

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
Reply With Quote