Re: $$Excel-Macros$$ Prompt / Ask the value & then calculate value-- 3 rd reminder

2016-01-26 Thread big smile
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

Re: $$Excel-Macros$$ Prompt / Ask the value & then calculate value-- 3 rd reminder

2016-01-26 Thread Paul Schreiner
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

$$Excel-Macros$$ Prompt / Ask the value & then calculate value-- 3 rd reminder

2016-01-26 Thread big smile
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