[Solved] Formula =if help

I am looking to do the following formula and need help!

if f7>f9 than f7-f9 *e9(which is a percentage) =
Hello kolarj,
Thanks for sharing your problem with us. I understand you are looking for a formula to return a value based on condition. Developing a formula for the condition and output you require is possible. As I don’t have your dataset, I have taken the following dataset:
-OrfVwl8kOvdgUxq4v3cMqPXPe_45FqZdiHst0IlcpuIJinKF8Z9zH72Jsw-ORqMEg4-n0YMpAavnpdtBNvcNpNR0fu9yVy4Zr5R-CcAwF_qOx7fljuwie6VoCtmpxNiwoLIim-tHIeO9jD8zOjQarw

Assuming that you will start applying the formula from cell G9, I have applied the following formula in cell G9 and used the Fill Handle tool to copy the formula in the remaining cells.

=IF(F7>F9,(F7-F9)*E9,"Condition not met.")

5U3rg3o5vK3onlqfNAbjBEbn_3AYcS6oQqToseZR3xQiZ6WJHJrHfYL9C-dC7O9BF3TEZmGTTKhL_vpkW108XY2B-0TjjQw_amb_hpBEuoybn041nawVn4-yddxCnTErqKe2uJuTeJ36CnWvA-MGw5U

I hope this formula will accomplish your required task. If you want a more specific formula, please share a sample dataset with us.

Regards,
Team ExcelDemy
 

Online statistics

Members online
1
Guests online
15
Total visitors
16

Forum statistics

Threads
311
Messages
1,378
Members
568
Latest member
WilliamHon
Top