In excel can I display a cell based on a calculation (eg M(14/
You need to check what ROUNDDOWN($AA$1/$A11^D$37,0) evaluates to. It
needs to be a number between 1 and 65536. If it is likely not to be a
number you'll need to put some error checking in it and decide what you want
the value to be if there is an error.
Regards
Trevor
"rnrxtreme" wrote in message
...
Does this not work when there's a text command in the equation
I'm inputting =INDIRECT("B" & ROUNDDOWN($AA$1/$A11^D$37,0))
(all listed cells exist)
and it shows an error...
|