Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
.... or =A2+250*(A22000)
-- David Biddulph "Russell Dawson" wrote in message ... Hi Slater, Your description almost says it the way the formula goes although you have not said what you want the 250 to be added to. I've assumed that you want it to be added to the original figure in A2 so: =IF(A22000,A2+250,A2) That's saying If A2 is greater than 2000 then display A2 figure plus 250 otherwise just display A2 figure. -- Russell Dawson Excel Student Please hit "Yes" if this post was helpful. "slater" wrote: i am a new excell user 2007 how do i get the formula to say if A@ is greater than 2000 add 250 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Open 2000 file attachments in Excel 2000 | Excel Discussion (Misc queries) | |||
I cannot edit cell format in Excel 2000 (Part of office 2000)! | Excel Discussion (Misc queries) | |||
Using Excel 2000 as Data source for Word 2000 document | Excel Discussion (Misc queries) | |||
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file | Excel Discussion (Misc queries) | |||
Excel Programs developed in Office 2000 on Windows 2000 | Excel Discussion (Misc queries) |