Price Range

[pavlos95]

Hi all,

I'm trying to make a cost calculation but I don't know the exact price of some cost. It it possible to make the value a range, so that the final cost will also be a range?

[Glenn Kennedy]

It's not clear what you want. But here are two possibilities. the second possibility returns TEXT that just LOOKS like a number.

[llamafarmer]

To do it with formulas you would probably need to set up a few columns (or rows depending on how it is set up).

For instance you could have the following columns (actual, min, max) then use a formula to determine what values to display:

=if(ISBLANK(actual first cell),min first cell&"-"max first cell,actual)

That will return the actual value if there is one and will enter a text range if not, showing the min - max values, obviously that wont help with suming you min/max values but its a starting point, can you provide a small example of what you are trying to produce?

[pavlos95]

Dear Glenn,

The second example was the one I was looking for thanks!

[Glenn Kennedy]

As long as you realise that it is text... not a number.