The Motley Fool Discussion Boards

Previous Page

Computers, Phones & Internet / Spreadsheet Advice

URL:  https://boards.fool.com/can-someone-tell-me-how-to-create-an-34719364.aspx

Subject:  Re: Question about an "IF" statement Date:  1/11/2021  5:53 PM
Author:  warrl Number:  7255 of 7274

Can someone tell me how to create an "IF" formula that will do two separate things when the result is "True"?

For example (written in English): IF A6>0 then B6="123" AND C6="ABC" else B6=" " AND C6=" "


In cell B6: if(A6>0,"123","")
in cell C6: if(A6>0,"ABC","")

A formula in one cell is not allowed to directly change any other cell.

(Of course, the result of that formula can affect the results of other formulas.)
Copyright 1996-2021 trademark and the "Fool" logo is a trademark of The Motley Fool, Inc. Contact Us