Thanks for reply
I get the solution from Vaibhav Bhai .
It is working as per my query too
On 26 January 2016 at 19:04, Paul Schreiner wrote:
> To do what you're actually asking would take a great deal of programming.
>
> In Cell E26, a simple formula like:
> =IF(G26>70,70,G26)
>
> would look a
To do what you're actually asking would take a great deal of programming.
In Cell E26, a simple formula like:=IF(G26>70,70,G26)
would look at G26, and if it is more than 70, it returns 70.Otherwise, it
returns the actual value of G26.
However, you said you want accept ANY VALUE if it's <= 70.That
I have send this query on 21 st -- No body reply.
Is this possible or not
-- Forwarded message --
From: big smile
Date: 21 January 2016 at 08:12
Subject: $$Excel-Macros$$ Polite Reminer -- Prompt / Ask the value & then
calculate value
To: excel-macros@googlegroups.com
Hello Fr