Hello,
I am using the formula =MROUND(E31/E40*1000,10) but I need it to ignore one of the cells if they are blank but still carry out the formula after the cells, I am not great with Excel so any help would be appreciated.
Thanks!
Hello,
I am using the formula =MROUND(E31/E40*1000,10) but I need it to ignore one of the cells if they are blank but still carry out the formula after the cells, I am not great with Excel so any help would be appreciated.
Thanks!
Please clarify.
As stated the formula is not using a range of cells unless E31 or E40 refer to a range.
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
Richard,
Thanks for your reply, I have attached a copy with just the cells I need the formulas sorted out on which is E35, There is two boxes on the sheet one is E31 and the other is E32, there is formula in E40 which is worked out from both E31 and E32.
I basically need E32 to be ignored from the formula if it is blank and for E31 to be *1000 to the nearest 10 still if it is blank.
Thanks!
...would you give an example. For instance if E31 is 95 what do you expect in E35
...and if E32 contains say 25 what then?
I am going to change the numbers but if I had for example 2.452 in E31 with nothing in E32 I would expect 2450 in E35(sum of 2.452*1000 rounded to the nearest 10)
If I had 2.452 in E31 and 1.456 in E32 I would expect 2460 in E35 (sum of E31-E32/0.998)
I just want it to ignore the Sum in E40 if there is nothing in E32 and just work out the sum on the first line of this reply but then work out the second line if there is an input in E32.
One way
=MROUND(IF(E32="",E31*1000,E31/((E31-E32)/998)),10)
This doesn't need M40
That worked perfectly!
Thank you so much for you help!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks