PROBABLY A REALLY SIMPLE PROBLEM

[Herbie1809]

Hello Chaps,

I'm completely stuck on something that should probably be really simple.

I have an IF statement in a cell: =IF(Y2<=0,W4+1,1), but it does'nt seem to fire.

The value in Y2 is placed in the cell by VBA code. The value in W4 is a formula (which puts the correct value in the cell.

I've checked the value data types and they're all consistent, and I've checked the VBA code is not continuing to fire. Any ideas?



Cheers.

[osknows]

Hello,

Possibly it could the following....

cell Y2 may be being treated as text instead of numeric.

Eg if cell Y2 contains a formula

=IF(F5>2,F5,"")

The "" will show a blank in the cell but it isn't 0.

your formula =IF(Y2<=0,W4+1,1), Y2<=0 won't work in this case

You have 2 options, either
1. Change the formula in Y2 so only numeric data is returned - eg =IF(F5>2,F5,0)

or

2. Update your formula to read
=IF(OR(Y2<=0,Y2=""),W4+1,1)

If t's not that we probably need more info

Os

[osknows]

I just realised you're placing the value in Y2 via code. Again it could be the value you're writing is a string. Try using the correct type in VBA such as Long, Double etc or converting the number in VBA CLng, CDbl

Alternatively force Excel to convert by using

=IF(Y2*1<=0,W4+1,1)

[Herbie1809]

Cheers, Os. Much appreciated,mate