Forum Discussion
Need help with multiple IFs formula
I can't do this with a traditional IF formula. So, I've been trying to work out the IFS formula. It seems this should work but, something is off somewhere: =IFS(G19="Buy", ((H19*F19)*-1), G19="Se...
Now as we know the nature of the error perhaps a formula such as
= IF(LEFT(Type,1)="S", 1, -1) * volume*price
- (MID(Type,2,1)="T") * volume*rate/100
might do the job.
p.s. I have taken a blind guess at some names because I do not get on with direct cell referencing and have avoided them since 2015.