![]() |
|
#1
|
|||
|
|||
![]() 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) |
#2
|
|||
|
|||
![]()
That's great thanks,
I had a feeling it would be something simple, didn't realise it would be that simple ![]() |
![]() |
Thread Tools | |
Display Modes | |
|