**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.*