I have an excel file I built and the formula gives me the data how I want it but I have the blue triangles showing with the warning that says “this formula uses a Boolean in place of a number”. Any help to write a formula that does what I want without the blue triangles? Picture for my current formula.
iPad Pro, 11-inch, 4th Gen, Cell mmW
Why does the formula have ISBLANK(I5)?
Does this help: modify for your cells: C2 contains D2 if either F2 or G2 is not empty.
IF(OR(NOT(ISBLANK(F2) ),NOT(ISBLANK(G2))),D2,"")
You’re welcome.
Use copy and paste or ‘fill’ to copy the formula to other cells
Thanks for the reply! I will give it a try.
I want B6 to show what’s in C5 only if Q6 or R6 has a number in either one.
that’s is what the first blue triangle column formula is what I want. The formula that is showing is for below but for the blank cell that is selected. Does this make sense?
then I want H6 to show what’s in I5 only if Q6 or R6 has a number in either one
Can you say in words what the formula is supposed to do.
The x OR ISBLANK R7 may be problematic.
This may help now you can see the left column cell numbers. The far left column blue triangles are basically the same formula but putting the data from the C column
I do not know how you know this and can figure this out so fast but your are awesome! I really appreciate it! The blue flag is gone from the cell!!!! Now to type this in for each one ! Thanks!!!!
Numbers App help!
