Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 16th 18, 10:45 PM
Junior Member
 
First recorded activity by ExcelBanter: Sep 2018
Posts: 1
Default Conditional Formula for Week Mont year

Hi, treading some new ground in Excel, and trying to make a formula to either multiply or divide by 4 to complete a budgeting sheet for expenditure uncured either weekly, monthly or annually, based on the value inserted and the data valuation cell!

Any help is much appreciated!
Attached Images
 

  #2   Report Post  
Old July 14th 19, 10:34 PM posted to microsoft.public.excel.newusers
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2019
Posts: 2
Default Conditional Formula for Week Mont year

On Monday, 17 September 2018 03:19:12 UTC+5:30, Brian73 wrote:
Hi, treading some new ground in Excel, and trying to make a formula to
either multiply or divide by 4 to complete a budgeting sheet for
expenditure uncured either weekly, monthly or annually, based on the
value inserted and the data valuation cell!

Any help is much appreciated!


+-------------------------------------------------------------------+
|Filename: Capture.JPG |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=1059|
+-------------------------------------------------------------------+



--
Brian73


Can you send me a worksheet with some sample data and what you require to be done so I can try and find a solution to the problem? Thanks.
CA Vikram S. Mathur
  #3   Report Post  
Old December 24th 20, 11:28 AM
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 26
Default Formula & Data Validation

Let's say you had, in cell A1, a very simple formula, =A2+A3.
You can then apply Data Validation to that cell, to restrict user input, for example to a list.
As long as you apply them in that sequence (formula first, then DV), then Excel will let you do it.
The formula will calculate correctly, even if the result is not an allowable input as far as DV is concerned.
You will then be able to overwrite the formula, using DV.
Try it.

But I would be careful with this.
Partly because, once you've applied DV, it will be tricky to input the formula a second time, or even to change the formula, if you want to do that.
You'd have to take off DV to do that.

I would consider doing this in separate cells - have a formula that gives you one result.
Then have a separate DV cell, for optional user input.
Then have another formula, which says, IF the DV cell is blank, pickup the result of the first formula.
If the DV cell is NOT blank, pick up the value in the DV cell.

I hope I was able to give you some insights.

You can get more help with https://www.o365cloudexperts.com if needed.

Regards,
Jerry


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I get a formula to calculate the third Thursday of the mont Malinda Excel Discussion (Misc queries) 7 December 16th 08 03:34 PM
Auto calculate day of week to week of the year (not as serial) oftenconfused Excel Discussion (Misc queries) 4 June 23rd 08 05:14 PM
How do I crate a function for week of year + year in same cell. patty ann Excel Worksheet Functions 1 March 16th 08 06:34 PM
Need formula to have date in cell B2 rounded to first of next mont RamseyR Excel Worksheet Functions 3 October 20th 05 08:28 AM
day of year/week of year script Ed Excel Programming 3 May 30th 05 01:40 PM


All times are GMT +1. The time now is 12:29 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017