Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
In cell one I enter an amount this amount can change. cell two is multiplied by cell three the answer is calulated in cell four. I do not want the amount to be larger than cell one. if it is smaller thats ok but not larger.
|
#2
![]() |
|||
|
|||
![]() Quote:
Let´s suppose this scenery: A1 -- = 100...(THE AMOUNT THAT CAN BE CHANGED AS YOU SAID) B1 -- = 5.......(ANY VALUE) C1 -- = 10.....(ANY VALUE) D1 -- = FORMULA D1 -- =IF((B1*C1)<=A1,(B1*C1),"RESULT EXCEEDS A1 VALUE")
__________________
I hope it can help you. Best regards, Marcilio Lobão --------------------------- Belo Horizonte, Brazil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|