Thread: [Solved] IF formula using dates
View Single Post
 
Old 04-06-2015, 01:15 AM
skywriter skywriter is offline Windows 7 32bit Office 2010 32bit
Novice
 
Join Date: Apr 2015
Posts: 5
skywriter is on a distinguished road
Default

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.
Reply With Quote