Adding a figure + a percentage after using lesser than or greater
 

I have a column with an amount in and need a formula to add a figure to this
cell after using less than or greater than, after this to add a percentage
after determining the figure, hope this makes sense

Adding a figure + a percentage after using lesser than or greater
 

It doesn't make sense, sorry. Give an example with numbers.

Dave
--
Brevity is the soul of wit.


"stevemel50" wrote:

I have a column with an amount in and need a formula to add a figure to this
cell after using less than or greater than, after this to add a percentage
after determining the figure, hope this makes sense

Adding a figure + a percentage after using lesser than or grea
 

sounds sort of like:
I have a cell with a value. If the value is greater than some other value,
then divide my x. if less than the other value, divide by y. That's a wild
guess. If so:
Assuming the original valeu is in cell A2:
=if(A2 value,A2/x, A2/y)

Of course, I could be completely off the mark.


"Dave F" wrote:

It doesn't make sense, sorry. Give an example with numbers.

Dave
--
Brevity is the soul of wit.


"stevemel50" wrote:

I have a column with an amount in and need a formula to add a figure to this
cell after using less than or greater than, after this to add a percentage
after determining the figure, hope this makes sense