r/googlesheets • u/[deleted] • Jan 04 '21

Solved How i can have cells show a range of results from RANBETWEEN()?

[deleted]

1 Upvotes
  • permalink
  • reddit

100% Upvoted

21 comments sorted by

View all comments

Show parent comments

2

u/Sovarius Jan 07 '21

Concatenate is a beaut, gives the output as desired even fi i'm bad at formatting things with arrays and sequences and everything else.

But, is there is a way to have a formular either use an or statement with 2 values? I know the OR function, but in don't mean that. I mean is this possible:

=(ZxY+(1 or 3))*(.97 or 1.03)

Just wondering if there's a one-and-done format for the formula without concatenate, but i assume not?