LinkBack URL
About LinkBacks
Iandislikesformulas 
Hi All,
I'm currently using this formula,
=IF(ISBLANK(A1),"",IF(A1=70,RANDBETWEEN(1,1000),IF(A1=90,RANDBETWEEN(1,800))))
My problem is, once the number is generated I need it to not change every time the sheet is calculated.
Hi All,
I'm currently using this formula,
=IF(ISBLANK(A1),"",IF(A1=70,RANDBETWEEN(1,1000),IF(A1=90,RANDBETWEEN(1,800))))
My problem is, once the number is generated I need it to not change every time the sheet is calculated.
Last edited by Iandislikesformulas; 08-31-2010 at 08:43 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks