Spreadsheet Wizard Needed

[Granny]

This is for all you Spreadsheet Wizards. I have been trying (in vain) to come up with a working formula that will do the following:

IF C4 is equal to or greater than today's date, THEN G4 equals E4 times 10%, ELSE G4 equals 0 (zero)

BTW: I am working with OpenOffice Calc

 

[gdub00d]

This works in excel - pretty sure this will get you close in OpenOffice...

=IF(C2>=DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())),E2*10%,0)

 

[gdub00d]

Here it is for OpenOffice...


=IF(C2>=DATE(YEAR(NOW());MONTH(NOW());DAY(NOW()));E2*0.1;0)

or

=IF(C2>=DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()));E2*0.1;0)

 

[RatLabGuy]

Wow, $125 in 10 years? Acme bird seeds needs a better investment model...

 

[Granny]

Wow, $125 in 10 years? Acme bird seeds needs a better investment model...

I knew someone would jump on that!

 

[Granny]

Here it is for OpenOffice...


=IF(C2>=DATE(YEAR(NOW());MONTH(NOW());DAY(NOW()));E2*0.1;0)

or

=IF(C2>=DATE(YEAR(TODAY());MONTH(TODAY());DAY(TODAY()));E2*0.1;0)

Just gave this a quick try. It always returns zero ($0.00).
I will play with more it this evening... gotta Jeep to be working on, ELSE Yager will be bitchin' at me again!

 

[gdub00d]

Here is a sample sheet (OpenOffice) - it works fine on my end - what date are you using???

http://lknlife.com/nc4x4sheet.ods

 

[Granny]

I screwed up... gave y'all wrong formula description.

BUT... finally got it figured out.