Question description:
This user has given permission to use the problem statement for this
blog.
I am making a conversion chart. the formula I am using is =IF(C31<>0,(C31-29.7)/131.8+B31,""). This outputs to column D. This way, if column C is blank, the formula is ignored. If column B has a value, but column C does not, I want to ignore the formula and simply have column D equal Column B. If both C and B have a value, I want to run the formula which alters C and adds B.
Solved by F. Y. in 33 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/01/2018 - 05:35
Welcome, Thanks for choosing Got It Pro-Excel
User
27/01/2018 - 05:36
HI
Excelchat Expert
27/01/2018 - 05:36
Can you please list down the condition one by one so that it is easier for me to understand
User
27/01/2018 - 05:37
ok.how do I alter formulas on this sheet?
Excelchat Expert
27/01/2018 - 05:38
Please list the conditions so that I can construct the formula for you
Excelchat Expert
27/01/2018 - 05:38
You can press F2 on the DOC PREVIEW Page to alter formulaes
User
27/01/2018 - 05:38
If c3 is blank, total kegs = b3
User
27/01/2018 - 05:39
If b3 and c3 have value, run this formula(C31-29.7)/131.8+B31
User
27/01/2018 - 05:40
only, it would be c3 and b3 not c31 and b31
User
27/01/2018 - 05:40
If both cells are blank, ignore formula
User
27/01/2018 - 05:43
my formula works, but If both cells are blank, I want nothing in column d
Excelchat Expert
27/01/2018 - 05:43
Checking it
Excelchat Expert
27/01/2018 - 05:44
Please be online
Excelchat Expert
27/01/2018 - 05:45
=IF(ISBLANK(C1),B1,IF(AND(ISBLANK(B1)=FALSE,ISBLANK(C1)=FALSE),(C1-29.7)/131.8+B1))
Excelchat Expert
27/01/2018 - 05:45
Please check if this works'
Excelchat Expert
27/01/2018 - 05:45
Used 1st row instead of 3rd row
User
27/01/2018 - 05:48
it's very close. the only issue is that when b is blank, but c is not, it outputs false.
Excelchat Expert
27/01/2018 - 05:48
What condition do you want there?
User
27/01/2018 - 05:50
if b is blank, but c is not, then (C1-29.7)/131.8
User
27/01/2018 - 05:50
if c is blank, but b is not, then = b
User
27/01/2018 - 05:50
if both cells are blank, output nothing
User
27/01/2018 - 05:51
if both cells have a value, (C1-29.7)/131.8+B1)
Excelchat Expert
27/01/2018 - 05:51
I asked you to list all the conditions at the beginning but u gave me incomplete info that lead to this
Excelchat Expert
27/01/2018 - 05:51
Working on it again
User
27/01/2018 - 05:51
you're doing great.
User
27/01/2018 - 05:51
almost there.
Excelchat Expert
27/01/2018 - 05:55
=IF(AND(ISBLANK(B1),ISBLANK(C1)=FALSE),(C1-29.7)/131.8,IF(AND(ISBLANK(C1),ISBLANK(B1)=FALSE),B1,IF(AND(ISBLANK(B1),ISBLANK(C1))," ",IF(AND(ISBLANK(B1)=FALSE,ISBLANK(C1)=FALSE),(C1-29.7)/131.8+B1))))
Excelchat Expert
27/01/2018 - 05:56
Please check this
Excelchat Expert
27/01/2018 - 05:59
I have also done the formula on the Doc Preview page please check
User
27/01/2018 - 05:59
I think that does it. Thank you very much.
User
27/01/2018 - 05:59
you have been most helpful.
Excelchat Expert
27/01/2018 - 05:59
Is there anything else you want to know regarding this issue?
User
27/01/2018 - 05:59
no thank you. You've done a great job.
Excelchat Expert
27/01/2018 - 05:59
Thanks for using Got It Pro-Excel
Please give your kind feedback for our service
Have a good day ahead!
Excelchat Expert
27/01/2018 - 06:00
You may want to end the session now
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.