Hello, I'm recreating a document that has had a corruption and I'm struggling to get an IF formula to calculate properly.
The formula is =IF(--W2>=$Z$6,2,1) on the pagem 'Formula' in X2. Previously this has produced the information that I need correctly but now I can't see why it's failing to work.
Can anyone help?
In X2 drag it down...
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Or... change the formula in V2 to =MOD(U2,1) and copy down and leave the rest as it is.
If I've been of help, please hit the star
Thanks guys, sorted!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks