Software

Ask something
Discussion Locked

Excel Formula and calander

0 helpful
3 replies

by whatme?

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

This has 2 parts to it.
First, I need a formula for: I have a dropdown list in cell h38 (yes or No)
If H38 is Yes then I want the formula =sum(e38*G38)*.07(E38*g38)
If Hs8 is NO then I want the formula =sum(e38*G38)

Secondly, I have multiple cells that need a date inserted. Is there a popup calander ,3rd party or otherwise that I could use, so that when a person clicks on that cell, they then can choose a date on a visual calandar?

Thankyou

3 replies

by dklippert

The formula is easier:
If(H38="Yes",sum(e38*G38)*.07(E38*g38),sum(e38*G38)*.07(E38*g38))

For the visual calendar:
Select a cell. Go to Insert>Object and choose "Calendar Control (9.0/10.0 depending on your version).
Go to View>Toolbars ControlToolbox. Turn on Design View (the first Icon) click on the Properties icon (hand with a piece of paper).
Make sur the Calendar is selected. You can now enter a Linked cell.

by whatme?

The formula worked with a little tweaking
but the calandar doesn't help. I need to click on a cell and have it pop up. When I enter a date I want the date to go into that cell...did that by linking, but I need to have the calandar disappear until I select another cell. I have 14 of these in this spreadsheet.

sorry. I have to click unacceptable so far even though you helped a lot

This discussion is closed to new replies.