Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Does anyone have any suggestions on how to set the formula?
There is a given number 430 in cell A1, if this number is greater than 360, then 430/10 = 43, it should return 43 in cell B1. There is a given number 4300 in cell A1, if this number is greater than 360, then 4300/100 = 43, it should return 43 in cell B1. There is a given number 43000 in cell A1, if this number is greater than 360, then 43000/1000 = 43, it should return 43 in cell B1. Does anyone have any suggestions on how to set the formula? Thanks in advance for any suggestion Eric |