![]() |
formula
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.
|
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") |
All times are GMT +1. The time now is 08:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com