• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

2 functions in one cell? Is it possible?

K

KEEEEBS24

New Member
Hello -

I am wanting to create a formula that will result in a value or zero based on the text of another cell. Example listed below has cell F2 resulting in "ZERO" which is fine. I also would like it to populate (C3*30) if the text in the C column is "STUDIO". Is there a way to do this automatically if I change the text in the C column? Thank you, any assistance is greatly appreciated :)

1722371999049.png
 
=IF(C3="HOME,"ZERO",IF(C3="STUDIO",C3*30,"STUDIO"))

This won't work, though, unless there's a number in C3, and there can't be both STUDIO and a numbaer - change the C3 in red to what you really meant.
 
Based on your sample, I think you mean:
=IF(C3="HOME","ZERO",if(c3="STUDIO",30*E3,"")

But you didn't say what you wanted to do if it wasn't HOME OR STUDIO. I left that blank at the end of the formula, you'll need to change that to what you want to do in that case.
 
You must log in or register to reply here.
Back
Top