If your formula is exactly as you wrote it.
=IF(B14>C1,"=G14",0)+IF(B14=C1,"=G14",0)
then your problem is "=G14", you don't use quotes and you don't use the = sign.
It should be written as so.
=IF(B14>C1,G14,0)+IF(B14=C1,G14,0)
To explain this formula just to confirm that it's set to do what you want.
If B14 is greater than C1, you get the value in G14, otherwise you get 0.
The second part, if B14 = C1, it will return the value in G14, otherwise 0.
You are adding these two together, but since it can't be greater than and equal to at the same time I think your formula would be better to look like this.
=IF(B14>=C1,G14,0)
This say if it's greater than OR equal to give me the value in G14, otherwise return 0.
|