Simon Lee
New Member
Hi there
Been a while and I'm struggling on a particular problem.
The formula I am using to produce a result in Cell D3 is =IF(B3<A3,"=B3","0")
At the moment I get the TEXT B3 in D3 when B3 is less than A3 when I actually want it to return the VALUE in Column B3, being the number 34.
When B3 is equal to or more than A3 I correctly get the desired numerical return of 0
What am I missing here, I can't see the wood for the trees right now
Been a while and I'm struggling on a particular problem.
Code:
A B C D
1 ALLOCATION ACTUAL TEAM PENALTY PENALTY
2 FOR 2015 NNT FOR 2015 NNT CAPPED 2016 CAPPED 2016
3 35 34 -1.00 =B3
4 21 23 2.00 0
The formula I am using to produce a result in Cell D3 is =IF(B3<A3,"=B3","0")
At the moment I get the TEXT B3 in D3 when B3 is less than A3 when I actually want it to return the VALUE in Column B3, being the number 34.
When B3 is equal to or more than A3 I correctly get the desired numerical return of 0
What am I missing here, I can't see the wood for the trees right now
Last edited by a moderator: