Excel Formula

		Microsoft Office Forums > Microsoft Excel > Excel
Excel Formula

FAQ

Thread Tools

Display Modes

08-01-2018, 02:36 AM

breen77

Windows 8

Office 2010 32bit

Novice

Join Date: Jul 2016

Posts: 24

Excel Formula

Hi

I have been wrecking my brains to try and achieve this. I have a formula at present which does a calculation if a cell is not blank but I also want to cap the calculation even the calculation is greater than another cell.

=IF(S26 = "", "", (S26*Q26)) - (current formula)

any ideas?

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Excel Formula	ctruggles	Excel	1	12-05-2016 12:12 PM
Excel Formula Bar	powrus1	Excel	4	07-19-2016 09:19 AM
excel formula	jcaal50	Excel	6	05-16-2014 04:01 PM
Help with excel formula	GoldenSlumbers	Excel	2	12-13-2012 03:32 AM
excel help Formula	sellspeed	Excel	15	03-10-2010 10:57 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 05:38 AM.